Support `array_distance` in `array_expression`

[Weijun-H]

Is your feature request related to a problem or challenge?

The current implementation of array_expression.rs lacks support for the array_distance functionality. This feature is essential for users who want to calculate distances between arrays using specific metrics or custom distance functions.

expect result

array_distance([1, 2, 3], [4, 5, 6]) --> 5.196152422706632
array_distance([1, 2, 3], [4, 5, 6], 'l1') --> 3
array_distance([1, 2, 3], [4, 5, 6], 'l2') --> 5.196152422706632

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

list_distance duckdb l1distance clickhousel1distance l2distance clickhouse

[Weijun-H]

I will work on this task if no one else wants to.

[Weijun-H]

It seems like it could be done after #7213.

[Tangruilin]

@Weijun-H , I am interesting in this issue.

[Weijun-H]

@Weijun-H , I am interesting in this issue.

Hi @Tangruilin , I think this issue is stalled by #8708

[Weijun-H]

support the column value