Add Scalar and Aggregate Distance UDFs

[austin362667]

Is your feature request related to a problem or challenge?

1. Since there are aggregate functions like corr and covar, it makes sense to me that we should add aggregate distance.
2. Beyond the aggregate function, it might also be valuable to add scalar UDFs like list_distance/array_distance, similar to DuckDB, along with other methods of distance measurement (e.g., like cosine etc). Please check Support array_distance in array_expression #8782

This function is particularly useful for scenarios involving spatial analysis, clustering, or similarity computations, where distance metrics are crucial.

Describe the solution you'd like

XREF: DuckDB list functions, array functions

side note: list and array are different by their own definition.

Describe alternatives you've considered

No response

Additional context

No response

[Weijun-H]

related #8782

[austin362667]

Thank you for bringing the related issues to my attention. I've updated the second part accordingly.

[austin362667]

Closing because aggregate distance might not be as helpful as array_distance,