Combined data change and retrieval

Apache DerbyBigQueryDb2 (LUW)H2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite2009201120132015201720192021⊘ 3.21.0 - 3.43.0⊘ 2017 - 2022⊘ 10 - 16⊘ 18c - 21c⊘ 8.0.11 - 8.0.34⊘ 10.3 - 10.11⚠ 2.0.202 - 2.2.220a⚠ 1.4.200⊘ 1.4.192 - 1.4.199⚠ 9.7 - 11.5.8ab⊘ 2.0⊘ 10.15.1.3 - 10.16.1.1
  1. Without merge
  2. Only if top-level statement is select: insert into … select … final from (delete from …)