DuckDB MERGE UPSERT + Incremental Updates — Cut Daily Reports from 2 Hours to 30 Seconds
Section
320 pages
Posts
DuckDB v2.0 JSON Patch Functions: SQL-First Data Reconciliation
DuckDB LIST Functions & PIVOT Syntax: The Complete Guide to Nested Data and Data Warehousing
DuckDB Advanced Aggregation: STRING_AGG, ARRAY_AGG, MAP_AGG in One Line
DuckDB One Trick: DML Inside CTEs — ETL Pipelines in a Single Query
Building a Multi-Tenant Analytics System with DuckDB: One Codebase, Multiple Clients
DuckDB 5 Advanced SQL Techniques: The Complete Guide to Doubling Performance
DuckDB's Nested Data Trinity: LIST, STRUCT, MAP in One SQL Query
DuckDB's 5 Killer JSON Functions: From Extraction to Aggregation in One SQL
Build a Personal Data Product Backend with DuckDB in 30 Lines of Code
