Query: improve null semantics around bitwise operators

[maumar]

Queries that use flags enums, passed as parameters will be expanded to:

(column | flagPrm) = flagPrm

which then is translated to:

((column | flagPrm) = flagPrm) AND ((column | flagPrm) IS NOT NULL AND flagPrm IS NOT NULL

this is because at the time of translation we don't know if flagPrm is null or not. Once we peek into the parameter values we can easily optimize out the flagPrm IS NOT NULL term, but unnecessary bitwise part persists.

We should break it down into components, i.e. (a | b) IS NULL <=> a IS NULL OR b IS NULL (same goes for (a & b)

[maumar]

general case: #16078

[maumar]

closing in favor of #16078