expressions ⓷

BigQueryDb2 (LUW)DuckDBH2MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite20052007200920112013201520172019202120232025✓ 3.5.7 - 3.53.0⚠ 2008R2 - 2025a⚠ 8.3 - 18a✓ 11gR1 - 23.26.1✓ 5.0 - 9.7.0✓ 5.1 - 12.2.2⚠ 1.4.191 - 2.4.240a✓ 1.0.0 - 1.5.0✓ 9.7 - 12.1.4✓ 2.0+
  1. Expressions cannot contain select-names:
    select c AS x FROM (VALUES (1), (2)) t(c) ORDER BY x * 2