Changes a delete from query into a delete top from query.

top clause is only supported by some dialects like MS SQL Server.

Examples

Delete the first 5 rows:

await db
  .deleteFrom('person')
  .top(5)
  .where('age', '>', 18)
  .executeTakeFirstOrThrow()

The generated SQL (MS SQL Server):

delete top(5) from "person" where "age" > @1

Delete the first 50% of rows:

await db
  .deleteFrom('person')
  .top(50, 'percent')
  .where('age', '>', 18)
  .executeTakeFirstOrThrow()

The generated SQL (MS SQL Server):

delete top(50) percent from "person" where "age" > @1