Subquery Flattening and Unnesting

Rewrite nested subqueries to enable the optimizer to use join-based indexing strategies.