import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.3/deps.ts";
const { MergeQueryBuilder } = kysely;
Adds the using
clause to the query.
This method is similar to {@link SelectQueryBuilder.innerJoin}, so see the documentation for that method for more examples.
Examples
const result = await db.mergeInto('person')
.using('pet', 'person.id', 'pet.owner_id')
.whenMatched()
.thenDelete()
.execute()
The generated SQL (PostgreSQL):
merge into "person"
using "pet" on "person"."id" = "pet"."owner_id"
when matched then
delete
Type Parameters
TE extends TableExpression<DB, TT>
K1 extends JoinReferenceExpression<DB, TT, TE>
K2 extends JoinReferenceExpression<DB, TT, TE>
Returns
ExtractWheneableMergeQueryBuilder<DB, TT, TE, O>
Type Parameters
TE extends TableExpression<DB, TT>
FN extends JoinCallbackExpression<DB, TT, TE>
Returns
ExtractWheneableMergeQueryBuilder<DB, TT, TE, O>