Support all array operators to work with columns

### 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_

Start by reading the current implementations of the array operators and the linked Arrow DataFusion discussion (6855), then trace how operator expressions handle columns. Clarify the complete operator list, including the discrepancy between “four” and the three listed operators, and define done as each agreed operator working with array columns.

Written by the indexing model from the issue text.