feat: Add multi-statement transaction support #2622

Job	Run time
Unit Tests (Python 3.9, min deps)	53s
Unit Tests (Python 3.9, default deps)	30s
Unit Tests (Python 3.10, default deps)	31s
Unit Tests (Python 3.10, min deps)	54s
Unit Tests + PyArrow (Python 3.11, default deps)	54s
Unit Tests + PyArrow (Python 3.10, default deps)	1m 5s
Unit Tests + PyArrow (Python 3.11, min deps)	1m 12s
Unit Tests + PyArrow (Python 3.9, min deps)	1m 17s
Unit Tests (Python 3.11, min deps)	55s
Unit Tests (Python 3.11, default deps)	29s
Unit Tests + PyArrow (Python 3.12, default deps)	57s
Unit Tests (Python 3.12, default deps)	31s
Unit Tests + PyArrow (Python 3.9, default deps)	1m 0s
Unit Tests + PyArrow (Python 3.13, default deps)	58s
check-types (3.11)	29s
Unit Tests + PyArrow (Python 3.10, min deps)	1m 16s
check-types (3.10)	38s
check-types (3.9)	46s
check-linting (3.9)	44s
check-types (3.13)	34s
check-linting (3.12)	25s
check-linting (3.13)	26s
check-types (3.12)	36s
Unit Tests (Python 3.13, default deps)	33s
check-linting (3.11)	28s
check-linting (3.10)	28s
	19m 29s

Provide feedback