Implement the bitwise complement operator

[RTEnzyme]

Is your feature request related to a problem or challenge?

The issue #1619 have discussed the bitwise operations. And some of the operations have been implemented: &, #, |, << and >>.

But the unary bitwise Complement operator ~ hasn't been implemented. I believe that the addition of the bitwise ~ operator would be a valuable addition to the existing set of bitwise operators.

Describe the solution you'd like

I would appreciate any suggestions on how to approach this task.

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

In order to implement this feature I would suggest extending Expr::Not to work with integral types

https://github.com/apache/arrow-datafusion/blob/8594ec73184b348ba23cf23458f1fc5340505d13/datafusion/expr/src/expr.rs#L104C51-L105

There is already an arrow kernel that can be used: https://docs.rs/arrow/35.0.0/arrow/compute/kernels/bitwise/fn.bitwise_not.html

You may also have to figure out how to get the ~col to work -- sqlparser supports it -- https://docs.rs/sqlparser/0.32.0/sqlparser/ast/enum.UnaryOperator.html#variant.PGBitwiseNot

[RTEnzyme]

In order to implement this feature I would suggest extending Expr::Not to work with integral types

Thanks for your suggestion, I'll do my best to implement it.