DuckDB

Specific best practices and architectural patterns when working with DuckDB.

Language / Topic

SQL

Rules

DuckDB · balanced balanced

- Perform data extraction perfectly parsing direct remote links configuring exactly native `read_parquet('s3://...')` integrations.

- Filter array collections explicitly utilizing exact vectorized `LIST_EXTRACT` functionality formatting nested queries naturally.

- Load CSV components dynamically guessing robust schema configurations executing native `read_csv_auto` cleanly.

- Compute rolling aggregations swiftly formatting standard analytical `OVER (PARTITION BY ...)` definitions purely independently.