Add method to perform all sql tests via FFI wrapped functions

### Is your feature request related to a problem or challenge?

As a follow on to the function work in #14562 we should add a way to run all of the existing tests through the FFI interface. This would give far greater confidence that the tests work as expected.

### Describe the solution you'd like

It would be great to make a special session context that does not register any functions at all. Instead we grab all the default functions, turn them into FFI variants and then Foreign functions, and register those. Then run all tests using that session context to validate they all work as expected.

### Describe alternatives you've considered

Continue building unit tests in FFI one by one

### Additional context

_No response_

Start with the function work referenced in #14562 and review how the existing SQL tests create their session context. Trace default function registration, then determine how to replace those functions with FFI-wrapped foreign functions for the full test suite. Done means all existing tests run through the FFI interface and validate the wrapped functions.

Written by the indexing model from the issue text.