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