feat: Add multi-statement transaction support #2621

Job	Run time
Unit Tests (Python 3.9, default deps)	52s
Unit Tests (Python 3.10, default deps)	43s
Unit Tests (Python 3.12, default deps)	38s
Unit Tests (Python 3.13, default deps)	39s
Unit Tests (Python 3.11, min deps)	1m 7s
Unit Tests (Python 3.10, min deps)	58s
Unit Tests + PyArrow (Python 3.10, min deps)	1m 9s
Unit Tests + PyArrow (Python 3.12, default deps)	56s
Unit Tests + PyArrow (Python 3.9, default deps)	1m 2s
Unit Tests + PyArrow (Python 3.11, default deps)	53s
Unit Tests + PyArrow (Python 3.10, default deps)	1m 2s
Unit Tests + PyArrow (Python 3.9, min deps)	1m 19s
check-linting (3.9)	40s
check-linting (3.10)	36s
Unit Tests + PyArrow (Python 3.13, default deps)	1m 3s
check-linting (3.11)	33s
check-linting (3.12)	31s
Unit Tests + PyArrow (Python 3.11, min deps)	1m 14s
check-types (3.11)	40s
check-linting (3.13)	38s
check-types (3.10)	48s
check-types (3.12)	46s
check-types (3.9)	47s
Unit Tests (Python 3.9, min deps)	55s
Unit Tests (Python 3.11, default deps)	45s
check-types (3.13)	38s
	21m 52s

Provide feedback