Rework auto begin/commit/rollback transaction during query lifetime (… #14679

Job	Run time
sanity checks	13s
python lint check	22s
rustfmt check	11s
clang format	34s
rust build & test	32m 18s
shell test	13m 18s
clang tidy & clangd diagnostics check	15m 26s
generate binary dataset	1m 11s
gcc build & test	24m 10s
webassembly build & test	29m 17s
clang build & test	7m 20s
code coverage	32m 55s
apple clang build & test	4m 55s
msvc build & test	33m 55s
macos extension test	44s
clang build & test with page_size_log2=16	5m 37s
clang build & test with page_size_log2=18	6m 34s
gcc build & test in-mem only with various vector size	3m 37s
linux extension test	26m 47s
gcc build & test with asan	25m 15s
benchmark / benchmark	12m 36s
windows extension test	7m 55s
report benchmark result	0s
	4h 45m 10s

Provide feedback