Dialects that support ANSI-standard OVER (...) window function syntax.
All of these are ANSI SQL:2003 window-function compatible in their modern
versions:
mysql (8.0+), mariadb (10.2+): full support
postgres, cockroachdb, redshift: full support (Redshift/CockroachDB are
Postgres-derived and share the same syntax)
mssql: full support since SQL Server 2012 (frame clauses since 2012)
oracle: full support (analytic functions), including RESPECT/IGNORE NULLS
sqlite: full support since 3.25.0 (2018)
db2: full support (OLAP specification)
snowflake: full support
clickhouse: full support since 21.3+ (contrary to older assumptions,
ClickHouse does implement standard OVER (...) window functions, it's
just historically been a later addition than in other engines)
Dialects that support ANSI-standard
OVER (...)window function syntax. All of these are ANSI SQL:2003 window-function compatible in their modern versions:OVER (...)window functions, it's just historically been a later addition than in other engines)