SQLAlchemy (which is sort of an embedded dsl for SQL) lets you give variable names to subqueries and as a result I don&#x27;t really use CTEs.  I bet the people using iBatis and JOOQ can do the same thing