insert … with … select

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021✓ 3.8.3+b⊘ 3.5.7 - 3.7.11⊘ 2008R2 - 2019b✓ 9.1+b✓ 8.4 - 9.0⊘ 8.3✓ 11gR2+a⚠ 11gR1a✓ 8.0.11+⊘ 5.0 - 5.7✓ 10.2+⊘ 5.1 - 10.1✓ 9.7+⚠ 2.0a
  1. Without column list: WITH name AS (SELECT…)
  2. Supports proprietary syntax with … insert … select