Six DuckDB-runnable SQL patterns from real data engineering work: snapshot resolution, member-month expansion, idempotent ingest, gaps and islands, SCD Type 2, window functions.
postgres sql etl analytics postgresql snowflake data-engineering scd-type-2 window-functions duckdb sql-recipes
-
Updated
May 7, 2026