Tags

7 pages

SQL Tips

DuckDB One Trick: DML Inside CTEs — ETL Pipelines in a Single Query

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: ROW_NUMBER() Overread Returns Wrong Numbers — And the 1-Line Fix

DuckDB One-Trick: Upsert Without MERGE Using INSERT OR REPLACE BY NAME

Merge Multiple DuckDB Files in One SQL Line: The Complete read_duckdb() Guide

Merge Multiple DuckDB Files in One SQL Line: The Complete read_duckdb() Guide

DuckDB QUALIFY Clause: Filter Window Functions Without Subqueries

DuckDB QUALIFY Clause: Filter Window Functions Without Subqueries

⚠️ This site is an independent community project, not affiliated with, endorsed by, or sponsored by the DuckDB Foundation or official DuckDB project.

"DuckDB" is a registered trademark of the DuckDB Foundation. This site uses the name solely for factual description purposes.

All content is for educational and community promotion purposes only and does not constitute any commercial service.