Description
Support cases like:
1) select ... from A join (select id, b from T limit 10) as B on A.id = B.id where B.b = 'b'
2) select ... from A join (select count c from T) as B on A.a = B.c where B.c > 10
These 2 cases cannot be handled by SubselectRewriter#applyPostFilters(), thus JoinCompiler should compile post-filters into query-plans for subqueries.