Support array_dot_product/list_dot_product #12475

Is your feature request related to a problem or challenge?

The current array-nested implementations lack support for the list_dot_product/array_inner_product functionality. This feature is essential for users who want to calculate dot product or even cosine distance between two numeric arrays. It might be useful in modern AI workloads, such as distance of two embeddings.

Expect result:

> select array_dot_product([1, 2], [1, -4]);
+---------------------------------------------------------------------------------+
| array_dot_product(make_array(Int64(1),Int64(2)),make_array(Int64(1),Int64(-4))) |
+---------------------------------------------------------------------------------+
| -7.0                                                                            |
+---------------------------------------------------------------------------------+
1 row(s) fetched.
Elapsed 0.004 seconds.

Describe the solution you'd like

Add support for array_dot_product/list_dot_product, just like what we did in array_distance/list_distance.

Describe alternatives you've considered

No response

Additional context

DuckDB supports list_dot_product and array_inner_product.

side note: In DuckDB, list and array have different definitions, and in DataFusion, they are considered the same.