What's New in SQLite 3.35
One thing to note about the `RETURNING` clause is that it can't be used in subqueries[0] or CTEs. One thing I do with Postgres is using multiple CTEs with `RETURNING` clauses to have a query with many steps, without having to open a transaction and doing many queries. The SQLite documentation says it's something that they want to implement. Having that would be very nice. We could do complex queries all at once without having to lock the DB during the whole transaction.<p>[0] <a href="https://sqlite.org/draft/lang_returning.html#limitations_and_caveats" rel="nofollow">https://sqlite.org/draft/lang_returning.html#limitations_and...</a>