for system_time as of …

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 2016 - 2019d✓ 10.3+✓ 10.5+⚠ 2.0b⚠ 2.0a
  1. Parameters (?) not supported
  2. Only proprietary table renaming syntax: FROM…AS <new name>…FOR SYSTEM_TIMME AS OF…
  3. Oracle’s “Flashback” offers similar functionality with a proprietary syntax
  4. Expressions not supported