import { kysely } from "https://dotland.deno.dev/x/kysely_postgrs_js_dialect@v0.27.4/mod.ts";
const { UpdateQueryBuilder } = kysely;
Changes an update
query into a update top
query.
top
clause is only supported by some dialects like MS SQL Server.
Examples
Update the first row:
await db.updateTable('person')
.top(1)
.set({ first_name: 'Foo' })
.where('age', '>', 18)
.executeTakeFirstOrThrow()
The generated SQL (MS SQL Server):
update top(1) "person" set "first_name" = @1 where "age" > @2
Update the 50% first rows:
await db.updateTable('person')
.top(50, 'percent')
.set({ first_name: 'Foo' })
.where('age', '>', 18)
.executeTakeFirstOrThrow()
The generated SQL (MS SQL Server):
update top(50) percent "person" set "first_name" = @1 where "age" > @2
Returns
UpdateQueryBuilder<DB, UT, TB, O>