Reference

Use Language Features to learn how a model fits together, Products for tooling, and Syntax Reference to look up a construct.

Area	Start here
Language features	Typing and validation, project layout, composability, functions and imports, context-sensitive functions
Products	Python SDK, CLI
Syntax reference	Datasources, functions, statements
Query examples	Query patterns, scalar calculations, aggregates and windows
Datasource examples	Files, scripts, multiple files, and read/write addresses
Worked examples	Ingest and query a CSV, query and build a public model

Function reference entries have a short description, type information, and an example. Expand Show Example, then Run to execute supported examples in the shared DuckDB demo. Copy includes any model setup the example needs. Examples that require local files or database extensions explain how to run them locally.