Teiid 8.10 added support for recursive common table expressions. There is no new syntax, but more logic around resolving a special form of a common table expression. If the query expression is written as a union then the right hand side of the union is allowed to reference the common table group. See https://docs.jboss.org/author/display/TEIID/WITH+Clause