feat: support `concat` with arrays and binary

[comphead]

What is the problem the feature request solves?

Follow up on #2604

Currently concat support string, but as per https://spark.apache.org/docs/latest/api/sql/#concat it should also support arrays and binary which are specific cases of arrays.

Depends on https://github.com/apache/datafusion/issues/18020

Describe the potential solution

No response

Additional context

No response