[FEATURE]: Ability to limit and order delete queries

[ajs11174]

Describe want to want

The .limit() and .orderBy() function should be available on delete queries.

await db.delete(tbl).where(eq(tbl.field, "some value")).orderBy(tbl.field).limit(10);

MySQL Reference

[coryvirok]

Not being able to limit deletes is pretty scary from a defensive programming perspective.

[wscotten]

bump! Would really like this since Planetscale limits deletes to 100k records at a time.

[davidchalifoux]

Bump! I would like to know that certain queries will only delete at max one item.
This would also be a great addition to update as well!

[fermentfan]

Is there any update to this? I would also love to be able to limit updates. Was really surprised that this isn't possible?