Where things fall apart is when you want to do things like a subquery on a select field.
Seems more like a limitation of particular implementation than a fundamental problem with the pattern.
Where things fall apart is when you want to do things like a subquery on a select field.