Push down null filters for other types than inner join

[Dandandan]

Is your feature request related to a problem or challenge?

We currently support pushing down null filters on inner join using the FilterNullJoinKeys rule.
We can however push down more filters for other types based on the on_lr_is_preserved condition

Describe the solution you'd like

Push down null filters based on on_lr_is_preserved

Describe alternatives you've considered

No response

Additional context

No response