How Bruin turns a SELECT query into 9 different materialization strategies across 14 databases

A deep dive into how Bruin's materialization system generates SQL for 9 strategies (merge, SCD2, delete+insert, etc.) across 14 databases using a simple dispatch table pattern.