Class WheneableMergeQueryBuilder

src/query-builder/merge-query-builder.ts:320–935

}

export class WheneableMergeQueryBuilder<
  DB,
  TT extends keyof DB,
  ST extends keyof DB,
  O,
>
  implements
    MultiTableReturningInterface<DB, TT | ST, O>,
    OutputInterface<DB, TT, O>,
    OperationNodeSource,
    Compilable<O>,
    Executable<O>
{
  readonly #props: MergeQueryBuilderProps

  constructor(props: MergeQueryBuilderProps) {
    this.#props = freeze(props)
  }

  /**
   * This can be used to add any additional SQL to the end of the query.
   *
   * ### Examples
   *
   * ```ts
   * import { sql } from 'kysely'
   *
   * await db
   *   .mergeInto('person')
   *   .using('pet', 'pet.owner_id', 'person.id')
   *   .whenMatched()
   *   .thenDelete()
   *   .modifyEnd(sql.raw('-- this is a comment'))
   *   .execute()
   * ```
   *
   * The generated SQL (PostgreSQL):
   *
   * ```sql
   * merge into "person" using "pet" on "pet"."owner_id" = "person"."id" when matched then delete -- this is a comment
   * ```
   */
  modifyEnd(
    modifier: Expression<any>,
  ): WheneableMergeQueryBuilder<DB, TT, ST, O> {
    return new WheneableMergeQueryBuilder({
      ...this.#props,
      queryNode: QueryNode.cloneWithEndModifier(
        this.#props.queryNode,
        modifier.toOperationNode(),
      ),
    })
  }

  /**
   * See {@link MergeQueryBuilder.top}.
   */
  top(