Support all array operators to work with columns

[izveigor]

Is your feature request related to a problem or challenge?

According the concept (See: https://github.com/apache/arrow-datafusion/discussions/6855) Arrow DataFusion should support at least four operators for working with arrays. But the current implementations of all operators can not work with columns. That fact reduces the user's ability to use these features in production.

The full list of operators 🎯:

• [ ] || (alias of array_concat)
• [ ] @> (alias of array_has_all)
• [ ] <@ (alias of array_has_all)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[Tangruilin]

It seems that || (alias of array_concat) is not supported now, maybe i can help with it

[Tangruilin]

It seems that || (alias of array_concat) is not supported now, maybe i can help with it

I'd like to ensure if it is supported, if not, this issue can be assigned to me

[Tangruilin]

https://www.postgresql.org/docs/16/functions-string.html

[Tangruilin]

https://www.postgresql.org/docs/16/functions-string.html

In pgsql, use || as alias of array_concat is supported, I ensure that datafusion do not support it now, I can help with it.