SQLite Forum

Are there any plans / chances of supporting a RETURNING clause?
Login
I've recently been re-using sqlite for personal software, and got annoyed several times at the necessity to work around the lack of `RETURNING` clauses when inserting rows, especially bulk-insert (even more so with upserts), as well as deleting rows.

I understand that since sqlite remains a single-writer system the concurrency aspects of `RETURNING` are not really a concern regardless of the operation, but `RETURNING` is oft extremely convenient, and quite simplifies the application code. I think it would be a boon.