Is your feature request related to a problem or challenge?
the PruningPredicate currently does not handle IS NOT NULL predicates
Describe the solution you'd like
No response
Describe alternatives you've considered
No response
Additional context
@appletreeisyellow added an initial implementation in #9208 but I believe it didn't work in all cases, as described in #9230