sql

dbt supercharges SQL with Jinja templating, macros, and testing -- all of which can be customized to enforce controlled vocabularies and their implied contracts on a data model

Using the tidyverse's expressive data wrangling vocabulary as a preprocessor for elegant SQL scripts