Support bitwise and boolean aggregate functions #6275
Description
Is your feature request related to a problem or challenge?
Bitwise and boolean aggregate functions are supported by a lot of databases and query engines (PostgreSQL, MySQL...). In my opinion, arrow-datafusion should also support these features.
Describe the solution you'd like
New aggregate functions:
Bitwise:
- bit_and
- bit_or
- bit_xor
Boolean:
- bool_and
- bool_or
Describe alternatives you've considered
No response
Additional context
MySQL: https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
PostgreSQL: https://www.postgresql.org/docs/current/functions-aggregate.html