Jaco van der Laan

SQL & generation

Recipe Cells

A declarative DSL where each step compiles to one single-concern CTE.

A recipe written as declarative cells — SOURCES, CLEANSES, FILTERS, AGGREGATES, SOURCE_MERGES — each compiling to exactly one focused CTE that does one kind of work. You declare intent per step; the engine emits clean, single-concern SQL. The notebook is the kitchen, the SQL file is the dish; a seam date marks where an old source table hands over to a new one.

← All concepts & vocabulary