Polyglot SQL API Documentation - v0.1.0
    Preparing search index...

    Class MergeBuilder

    Fluent builder for MERGE INTO statements.

    const sql = mergeInto('target')
      .using('source', col('target.id').eq(col('source.id')))
      .whenMatchedUpdate({ name: col('source.name') })
      .whenNotMatchedInsert(['id', 'name'], [col('source.id'), col('source.name')])
      .toSql();
    Index

    Constructors

    constructor

    Methods

    build free toSql using whenMatchedDelete whenMatchedUpdate whenNotMatchedInsert

    Constructors

    Methods

    • Return the Expression AST as a plain JS object.

      Returns any

    • Free the underlying WASM handle.

      Returns void

    • Generate SQL string. Defaults to generic dialect.

      Parameters

      • dialect: string = 'generic'

      Returns string

    • Add a WHEN MATCHED THEN DELETE clause.

      Returns this

    • Add a WHEN MATCHED THEN UPDATE SET clause.

      Parameters

      Returns this

    • Add a WHEN NOT MATCHED THEN INSERT clause.

      Parameters

      Returns this

    Settings

    Member Visibility

    On This Page

    Constructors
    Methods