Enhance bloom filter recommendation rule to also consider IN predicate

Support in the execution engine was added for bloom filter (#7005) based pruning using IN predicate. The index recommendation rule isn't yet updated to support IN predicate. The current implementation of BloomFilterRule ignores IN predicate, this issue will track removal of that limitation

Start by locating the BloomFilterRule implementation in the Java execution and index-recommendation code, then read the bloom-filter pruning support from issue #7005. Trace how the rule handles existing predicates and verify that IN predicates are covered by the recommendation behavior and its relevant tests.

Written by the indexing model from the issue text.