support common table expressions (CTEs) for Selects

[phderome]

I believe they are fairly standard for modify DML statements as well. This minimally looks like this syntax WITH...

[jdegoes]

I think we should support these in the rendering engines. This way, users can use val and def to abstract over duplication, and not have to worry that on appropriate backends, we do CTE extraction based on duplicated expressions.