The whole point of dbt is to bring software engineering principles to the handling of data for analytics. It's still SQL (as are all the modern data warehouses) because nothing else has beaten it.
SQL is amazing, I’m not convinced string templates and this one tool offer enough value to be worth the hype they receive.