Nested Queries

By Dick Dokter on 6 May 2010
To improve the understanding and readability of the application logic it would be great if the platform has the possibility to nest queries. This is now only possible in the advanced query using FROM ( SELECT * from ..........) or a foreach over the output of a query witch consumes a lot of unnecessary softwareunits.

It would be very helpful if it is possible query the output of a query.
Diogo Cordeiro27 Aug 2011
I think this would be interesting....if you really have the need for nested queries....

I wonder if there is any performance standard on these.
Kilian Hekhuis31 Aug 2011
Querying the output of a query could be very useful indeed, but that's something different from nested query's, which indeed can be solved by using an advanced query. However, the performance penalty may be high, as the query result must be stored inside a table for further querying etc.