From|Join (values …) t

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.8.3 - 3.39.0a⊘ 3.5.7 - 3.7.11⚠ 2008R2 - 2019ac⚠ 8.3 - 14a⊘ 11gR1 - 21c⚠ 8.0.19 - 8.0.30b⊘ 5.0 - 8.0.18⚠ 10.3 - 10.9.2a⊘ 5.1 - 10.2⚠ 9.7 - 11.5.7a⊘ 2.0
  1. Only without keyword row
  2. Requires keyword row: values row('r1c1','r1c2'), row('r2c1', 'r2c2')
  3. Needs from clause column renaming