for system_time as of …

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