v.20.7Performance Improvement

Allow Pushdown Predicate with Subquery Containing WITH Clause

Allow pushdown predicate when subquery contains WITH clause. This fixes #12293 #12663 (Winter Zhang).