any_value(…) filter(…) over(…)

BigQueryH2MySQLOracle DBPostgreSQL201320152017201920212023✓ 16 - 17⊘ 8.3 - 15⊘ 11gR1 - 23.9⚡ 5.7 - 9.4.0ab⊘ 5.0 - 5.6✓ 2.2.220 - 2.3.232⊘ 1.4.192 - 2.1.214⊘ 2.0a⊘ 2.0a⊘ 2.0a
  1. ⚡Might return null even if there are non-null values
  2. Not an aggregate function