dbt is the standard for data transformation in warehouses using SQL with version control, testing, and modularity.
Write SQL selects, dbt materializes as tables/views/incremental. Jinja adds programming constructs. Auto-generated docs with lineage graphs.
dbt Core is free. dbt Cloud from $100/mo provides managed IDE, scheduling, CI/CD, and semantic layer.