SQL
Overview
DuckDB's SQL dialect is based on PostgreSQL.
DuckDB tries to closely match PostgreSQL's semantics, however, some use cases require slightly different behavior.
For example, interchangeability with data frame libraries necessitates [order preservation of inserts](#docs:sql:dialect:order_preservation) to be supported by default.
These differences are documented in the pages below.