Pull conditions out of materialized subqueries

If the optimizer chooses to materialize a subquery then in many cases it makes sense to clone the subquery conditions that can be transformed into conditions for outer tables and to add the result of the transformation to the WHERE condition of the main query.