Remove scalar subquery physical expression error where it drops metadata

In the 54.1 update I had to set a configuration value to get tests to pass. I'm not sure if we can work around this or whether we have to wait for it to get fixed upstream, but I'd like to track this here because we'll want to remove it eventually to get better subquery evaluation. The usptream issue is https://github.com/apache/datafusion/issues/24933 ; the 54 update PR is https://github.com/apache/sedona-db/pull/1226 .

Start by reading the Apache DataFusion issue #24933 and the Sedona DB 54 update PR #1226 to identify the configuration workaround and the scalar subquery metadata error. Done means the workaround can be removed while the tests still pass and subquery evaluation improves, or the upstream fix is incorporated when available.

Written by the indexing model from the issue text.