Evaluate LHS subqueries once #15151

Job	Run time
Build Rust and run Go tests (blacksmith-6vcpu-macos-latest)	1m 12s
Build Rust and run Go tests (windows-latest)	6m 0s
Build Rust and run Go tests (blacksmith-4vcpu-ubuntu-2404)	3m 30s
Publish Go driver	25s
	11m 7s

Provide feedback