Jaco’s Substack

Jaco’s Substack

Reverse Engineering SQL into Functional Metadata Blocks

From legacy SQL to declarative YAML: abstracting PIVOTs, NORMALIZE, and beyond into reusable metadata

Jaco van der Laan's avatar
Jaco van der Laan
Oct 18, 2025
∙ Paid

From legacy SQL to declarative YAML: abstracting PIVOTs, NORMALIZE, and beyond into reusable metadata

When we reverse engineer existing SQL code into functional or logical metadata building blocks, we move from code-first to metadata-first thinking.
The goal is not to simply parse SQL, but to understand what it does — and then represent that behavior in a…

User's avatar

Continue reading this post for free, courtesy of Jaco van der Laan.

Or purchase a paid subscription.
© 2026 Jaco van der Laan · Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture