Is your feature request related to a problem or challenge?

Part of #9285
Substrait only register BuiltinScalarFunction.
If we port BuiltInFunctons to datafusion-functions-* crates, then substrait can't call ScalarFunction because they can't find, see: #9313 (comment)

Describe the solution you'd like

I'm not quiet clear how to solve this, maybe we can register the functions in datafusion-functions-* like before, i.e. using an enum to contain all functions?

Describe alternatives you've considered

No response

Additional context

No response