feat: Decorrelate more predicate subqueries #33781

Job	Run time
Check cargo fmt	43s
cargo check	6m 51s
build with wasm-pack	2m 33s
cargo test (macos)	10m 33s
cargo test (macos-aarch64)	9m 44s
Verify MSRV (Min Supported Rust Version)	8m 35s
Verify Vendored Code	51s
cargo test (win64)	58m 3s
cargo examples (amd64)	13m 45s
cargo test datafusion-cli (amd64)	3m 50s
cargo doc	3m 55s
cargo test (amd64)	11m 2s
cargo test doc (amd64)	15m 14s
verify benchmark results (amd64)	12m 3s
check Cargo.toml formatting	2m 56s
clippy	5m 37s
check configs.md and ***_functions.md is up-to-date	2m 58s
Run sqllogictest with Postgres runner	3m 38s
cargo test pyarrow (amd64)	2m 50s
cargo test hash collisions (amd64)	17m 4s
	3h 12m 45s

Provide feedback