DuckDB SQL Reference
This skill mirrors DuckDB current SQL documentation.
CRITICAL: Search references/sql/ before giving DuckDB SQL syntax, function signatures, type semantics, statement options, dialect compatibility, or query-planning guidance. Do not infer function names or argument behavior from other SQL engines.
Scope
references/sql/query_syntax/ - SELECT, joins, CTEs, windowing, FROM, QUALIFY, sampling, and related syntax.references/sql/statements/ - DDL, DML, COPY, secrets, extension commands, transactions, and maintenance statements.references/sql/functions/ - scalar, aggregate, window, utility, and table-function references.references/sql/data_types/ and references/sql/dialect/ - type behavior, identifiers, and compatibility rules.
Search
rg -n "SELECT|JOIN|COPY|CREATE|function|aggregate|window|type|cast|PostgreSQL" references/sql
Official source: https://github.com/duckdb/duckdb-web/tree/main/docs/current/sql.
1---2name: duckdb-sql3description: Use when writing, debugging, optimizing, or checking DuckDB SQL syntax, statements, functions, data types, dialect, or query semantics.4---56# DuckDB SQL Reference78This skill mirrors DuckDB current SQL documentation.910CRITICAL: Search `references/sql/` before giving DuckDB SQL syntax, function signatures, type semantics, statement options, dialect compatibility, or query-planning guidance. Do not infer function names or argument behavior from other SQL engines.1112## Scope1314- `references/sql/query_syntax/` - `SELECT`, joins, CTEs, windowing, `FROM`, `QUALIFY`, sampling, and related syntax.15- `references/sql/statements/` - DDL, DML, `COPY`, secrets, extension commands, transactions, and maintenance statements.16- `references/sql/functions/` - scalar, aggregate, window, utility, and table-function references.17- `references/sql/data_types/` and `references/sql/dialect/` - type behavior, identifiers, and compatibility rules.1819## Search2021```bash22rg -n "SELECT|JOIN|COPY|CREATE|function|aggregate|window|type|cast|PostgreSQL" references/sql23```2425Official source: `https://github.com/duckdb/duckdb-web/tree/main/docs/current/sql`.
wenerme