Support passing ConfigOptions to scalar functions via FFI #17035

Is your feature request related to a problem or challenge?

In #16970, @Omega359 added support for passing ConfigOptions to scalar functions so they can access the the session config options.

However, these couldn't be easily added to the FFI interface without breaking backwards compatibility

Describe the solution you'd like

Figure out if we want to pass the ConfigOptions to functions via FFI and if so how to do it

Describe alternatives you've considered

No response

Additional context

No response