Like what we have done for [] -> MakeArray.
It is possible to have the similar conversion for other List Operator in the early stage (Sql to LogicExpr).

• List || List -> array_concat Convert Binary Operator StringConcat to Function for array_concat, array_append and array_prepend #8636
• List || non-List -> array_append Convert Binary Operator StringConcat to Function for array_concat, array_append and array_prepend #8636
• non-List || List -> array_prepend Convert Binary Operator StringConcat to Function for array_concat, array_append and array_prepend #8636

TODO

• left <@ right -> array_has_all(right, left)
• left @> right -> array_has_all(left, right)
• list && list -> array_intersect Support AND operator as alias of array intersect function #8496

Other: clean up list/array coercion in datafusion/expr/src/type_coercion/binary.rs

Originally posted by @viirya in #8496 (comment)