lead and lag

BigQueryDb2 (LUW)MariaDBMySQLOracle DBPostgreSQLSQL ServerSQLite200520072009201120132015201720192021⚠ 3.25.0 - 3.40.0b⊘ 3.5.7 - 3.23.1✓ 2022+b⚠ 2019⚠ 8.4 - 15b⊘ 8.3✓ 19c+⚠ 8.0.11 - 8.0.31ae⊘ 5.0 - 5.7⚠ 10.2 - 10.10bd⊘ 5.1 - 10.1⚠ 11.5.0 - 11.5.7⚠ 2.0a⚠ 2.0d⚠ 2.0abd
  1. No negative offsets
  2. No respect|ignore nulls
  3. Proprietary nulls treatment: lead(<expr>, 'IGNORE NULLS') (it’s a string argument)
  4. No default possible (3rd argument)
  5. No ignore nulls