SQLite: Support ORDER BY and LIMIT in bulk update/delete
Open
area-bulkupdate
area-sqlite
- Dominant language
- C#
- Stars
- 14.8k
- Forks
- 3.4k
- PR merge metrics
- PR metrics pending
Description
SQLite supports ORDER BY and LIMIT if compiled with a specific option, [see docs](https://www.sqlite.org/compile.html#enable_update_delete_limit). I'm not sure what version we deliver and whether it has that option (plus IIRC on non-Windows we use the system-installed SQLite, where we have no idea). So this may need to be an opt-in context option.
In the meantime, ORDER BY and LIMIT are supported via a subquery pushdown, which is less nice and may have a perf impact (unconfirmed). We'd need to investigate more to understand if this is worth it.
Contributor guide
Assessment
This issue has not been assessed yet.