How I became an AST convert
A walkthrough by our solutions architect, Afzal Jasani, on changing his mental model of how SQLMesh works and how the underlying mechanics are extremely valuable.
A walkthrough by our solutions architect, Afzal Jasani, on changing his mental model of how SQLMesh works and how the underlying mechanics are extremely valuable.
Transpiling SQL is a hard problem. This blog series uses real-world transpilation challenges to explain how SQLGlot, the transpilation framework powering SQLMesh, tries to solve it.
The practice of augmenting SQL code with Jinja templates has gained significant traction and is consistently growing in popularity. However, is this truly the optimal approach? In this article, we examine the common challenges that arise when combining SQL and Jinja, while also suggesting a more effective method for metaprogramming in SQL.