Indeed one can think of a table expression as the trivial subquery SELECT * FROM table …well, modulo the fact that in a concrete sense that substitution w

Indeed one can think of a table expression as the trivial subquery SELECT * FROM table …well, modulo the fact that in a concrete sense that substitution would lead to infinite recursion!