Decompose row constructor equality with constants to enable zone map pruning - #24709

Fixes #23594

• Adds ConstantRowComparisonSimplificationRule, which decomposes top-level filter equality between a row constructor and a folded row constant (e.g. WHERE (id, b) = (42, 2)) into scalar equalities (id = 42 AND b = 2), so that the existing filter pushdown and zone map pruning machinery applies to such comparisons
• Handles bind-time type alignment: operands are compared in the aligned field type, so (a, b) = (42, 1.5) decomposes to a = 42 AND b = 2
• The rule only fires for row-constructor-vs-constant comparisons: row-vs-row comparisons are left to the existing RowComparisonSimplificationRule, and non-equality operators are untouched
• Tests: new test/sql/filter/test_tuple_comparison_pushdown.test, skipped in the disable_optimizer config since pruning requires the optimizer