SQL Update
Update with returning
You can update a row and get it back in PostgreSQL and SQLite:
WITH UPDATE clause
Using the with
clause can help you simplify complex queries by splitting them into smaller subqueries called common table expressions (CTEs):