Jaco van der Laan

SQL & generation

Concern Classification

Every CTE is labelled by the kind of work it does, so humans and AI know its role.

Each transformation step is explicitly typed by its concern — source (src_), filter (flt_), aggregate (agg_), deduplicate (dd_) — one CTE, one concern, one label. A signal AI assistants read to know what a step is for, and a rule the SQL Advisor enforces.

← All concepts & vocabulary