Lack of support for subqueries results in RuntimeException[BUG]

Describe the bug
Support for multiple subqueries seem to lack and results in a RuntimeException. This is an issue with a generated query by Power BI.

Or for query issues:

1. Run the query: select bool0, ITBL.C2, ITBL.C3 from (select bool0, C1, case when not C1 is null then cast(C1 as integer) else 0 end as C2, case when C1 is null then 0 else 1 end as C3 from (select bool0, bool0 as C1 from calcs ) as ITBL group by bool0, C1 ) as ITBL order by ITBL.C2, ITBL.C3 limit 501
2. See error RuntimeException
   

Expected behavior

Additional context
Removing the outer most query works. However, as soon as it is place in an outer query of even just SELECT * FROM (), then it does not work.