Idiomatic Materialize SQL chart

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

• SQL Functions
• SQL Types
• SELECT
• DISTINCT
• DISTINCT ON