[teiid-issues] [JBoss JIRA] (TEIID-4459) Convert project semi-joins to (dependent) join queries

Convert project semi-joins to (dependent) join queries ------------------------------------------------------ Key: TEIID-4459 URL: https://issues.jboss.org/browse/TEIID-4459 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1, 8.12.x-6.4 In many situations subqueries in the where clause can be planned as semi-joins. The same logic should be updated to handle the select clause. This will also help ensure better performance with odata generated array_agg queries.