Move make_array to datafusion-functions #9288

Is your feature request related to a problem or challenge?

Part of #9285 and #8045

The goal is to extract function definitions out of the datafusion core.

Note the make_array function is somewhat special in that it has several special cases in datafusion core at the moment.
Not only do the special cases make it hard to move, it also means some datafusion functionality is not available to scalar udf functions

I think this ticket will be blocked on removing the special case handling of MakeArrayin the expression rewriter(link) -- I will file a follow on ticket

Describe the solution you'd like

Move the make_array function to datafusion-functions-array

Describe alternatives you've considered

No response

Additional context

Note I have a draft PR with some of this code: #9222 but likely won't have time to work on it for a while