[ https://issues.jboss.org/browse/TEIID-4100?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4100: --------------------------------------- The approach that seems simplest here is to fetch the expanded entities inline using subqueries of the form: select parent cols ... (select array_agg((child cols)) [order by] from child ...), (select array_agg ...) ... This will create a tree of arrays that can be walked similar to the parent result set. This will not be as performant as the join approach for a single expand child, so there may need to be some thought put into converting a single subquery into a join (which we currently do for subqueries in the where clause). -- This message was sent by Atlassian JIRA (v6.4.11#64026)