rename columns in from clause

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⊘ 3.5.7 - 3.39.0⚠ 2008R2 - 2019b✓ 8.3+a⊘ 11gR1 - 21c⚠ 8.0.11 - 8.0.30⊘ 5.0 - 5.7⊘ 5.1 - 10.9.2✓ 9.7+⊘ 2.0
  1. Accepts missing column aliases
  2. Only for derived tables (not regular tables or views)