Factorize common AND factors out of OR predicates to support filterPushDown as possible

[Ted-Jiang]

Is your feature request related to a problem or challenge? Please describe what you are trying to do.
A predicate is of the from p AND q1 OR p AND q2 it would help to factorize out the AND factor p, to the equivalent expression p AND (q1 OR q2). This is useful when p contains predicates from just one col of a filter and can be pushed down

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

[alamb]

Sadly I had to revert #3859 so also reopening this one