Gate new ScalarSubqueryExec node behind session property #11045

Job	Run time
cargo test hash collisions (amd64)	11m 22s
Run sqllogictests with the sqlite test suite	27m 44s
cargo test 'extended_tests' (amd64)	34m 48s
	1h 13m 54s

Provide feedback