Idiomatic Materialize SQL

Materialize follows the SQL standard (SQL-92) implementation and strives for compatibility with the PostgreSQL dialect. However, for some use cases, Materialize provides its own idiomatic query patterns that can provide better performance.

Window functions

{{< yaml-table data="idiomatic_mzsql/toc_window_functions" >}}

General query patterns

{{< yaml-table data="idiomatic_mzsql/toc_query_patterns" >}}