v.22.2Performance Improvement

Reintroduce Scalar Subqueries Cache in Materialized Views Execution

Rework and reintroduce the scalar subqueries cache to Materialized Views execution. #33958 (Raúl Marín).