SQLite Forum

Retrieve a record and delete it
May I also point out that the DELETE statement allows a RETURNING clause? I find it quite useful.

Tangentially, PostgreSQL allows DELETE statements with a RETUNING clause as a common table expression to be used in a WITH clause. I use it sometimes to move data between tables. Possibly, SQLite users could benefit from the same feature.