SQLite Forum

Feature Request: DML RETURNING clause
Login
There's no standard that I'm aware of but it has support in postgres and mariadb (partial). Oracle and sql server have similar features in their procedural extensions.

Postgres compatibility would be my specific request: [https://www.postgresql.org/docs/13/dml-returning.html]

It doesn't really add any new capabilities but it does cut down on verbosity, especially when using a repl. I would think there are easy optimizations available, however, as the query and manipulation could be done in a single pass.

Apologies if this has been requested before. I couldn't find anything but it's not the most search-friendly term.


Oracle: [https://docs.oracle.com/cd/B28359_01/appdev.111/b28370/returninginto_clause.htm]

Sql server: [https://docs.microsoft.com/en-us/sql/t-sql/queries/output-clause-transact-sql?view=sql-server-ver15]

Mariadb:
  *  [https://mariadb.com/kb/en/insertreturning/]
  *  [https://mariadb.com/kb/en/replacereturning/]