Break-down functions-array subcreate' s kernels and udf containers

[erenavsarogullari]

Is your feature request related to a problem or challenge?

This issue aims refactoring by addressing following requirements:
1- functions-array subcreate is introduced in terms of Epic: #9285 and we can breakdown its kernels and udf containers to individual functions by aligning with our new pattern (a.k.a single func per file) for the consistency.
Ref: #9285 (comment)
2- We also need to use make_scalar_function in invoke calls (mentioned by @jayzhan211).
Ref: #9285 (comment)

Describe the solution you'd like

Break-down functions-array subcreate' s kernels and udf containers

Describe alternatives you've considered

No response

Additional context

No response

[erenavsarogullari]

take