Tags

9 pages

Practical Tips

DuckDB One Trick: Query Profile — Debug Slow Queries with SQL, Not Text Parsing

DuckDB One Trick: Replace Python List Comprehensions with LIST_FILTER and LIST_TRANSFORM

DuckDB One Trick: WITH ORDINALITY — Get Array Index While Unnesting Without Subqueries

DuckDB One Trick: QUALIFY Clause — Filter Window Results Without Subqueries

DuckDB One Trick: Merge Parallel Arrays with LIST_ZIP

DuckDB One Trick: Use RETURNING to Audit Your ETL in One Query

DuckDB One Trick: Export to Excel in One SQL Line (No Python, No Pandas)

DuckDB One Trick: Use RETURN_NULL_ON_ERROR for Dirty Data Import Without Crashes

DuckDB One-Liner: Wildcard JSON Path Queries for Nested Data