Back to Materialize

Idiomatic Materialize SQL chart

doc/user/content/transform-data/idiomatic-materialize-sql/appendix/idiomatic-sql-chart.md

123853 B
Original Source

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.

General

Query Patterns

{{% idiomatic-sql/general-syntax-table %}}

Examples

{{% idiomatic-sql/general-example-table %}}

Window Functions

{{< callout >}}

Materialize and window functions

{{< idiomatic-sql/materialize-window-functions >}}

{{</ callout >}}

Query Patterns

{{% idiomatic-sql/window-functions-syntax-table %}}

Examples

{{% idiomatic-sql/window-functions-example-table %}}

See also