Support Push Down Predicate for Final Subquery

Why it matters

This feature enables the ClickHouse query planner to push down filtering predicates into subqueries that use the FINAL modifier. It improves query performance by reducing the amount of data processed and returned in such scenarios, addressing inefficiencies in handling deduplicated or collapsed data within subqueries.

How to use it

Users can benefit from this improvement automatically when using subqueries with the FINAL modifier combined with filtering predicates. No additional configuration is needed; predicates in WHERE clauses inside or outside subqueries with FINAL are now more efficiently pushed down during query execution.