To expand on this, dbt uses Jinja templating in your SQL to allow the developer to modify the query so it can be expanded at "compile-time" into the target database SQL dialect. (uni-directional, write once deploy anywhere). The key features are CICD, test automation, and transformation sequence automation.
SQLGlot is a Abstract Symbol Tree SQL Dialect transpiler that could (in theory) convert from one dialect to another (bi-directional).
SQLMesh appears to combine both of the above into one tool that sounds like it's even better.
Comments
To expand on this, dbt uses Jinja templating in your SQL to allow the developer to modify the query so it can be expanded at "compile-time" into the target database SQL dialect. (uni-directional, write once deploy anywhere). The key features are CICD, test automation, and transformation sequence automation.
SQLGlot is a Abstract Symbol Tree SQL Dialect transpiler that could (in theory) convert from one dialect to another (bi-directional).
SQLMesh appears to combine both of the above into one tool that sounds like it's even better.