SQLite Forum

Are there any plans / chances of supporting a RETURNING clause?
Login
+1

If there is anybody who doubts that this is a useful feature, these are good readings:

  *  <https://www.postgresql.org/docs/current/dml-returning.html>
  *  <https://dzone.com/articles/the-returning-keyword-in-postgresql>

It saves a lot of round trips to the database after INSERTs and UPDATEs and allows deleting rows from one table while immediately inserting them into another. Advantages:

* Data are not transferred between client and server (in case of SQLite between the lib and the application).
* No explicit transaction is necessary as the whole statement is an autocommit transacation.