feat: Add multi-statement transaction support #2624

Job	Run time
check-types (3.10)	32s
check-types (3.9)	45s
check-types (3.11)	29s
check-types (3.12)	34s
check-linting (3.9)	41s
check-linting (3.10)	28s
check-types (3.13)	36s
check-linting (3.13)	30s
Unit Tests + PyArrow (Python 3.9, default deps)	1m 12s
check-linting (3.12)	25s
Unit Tests + PyArrow (Python 3.11, default deps)	53s
Unit Tests + PyArrow (Python 3.10, min deps)	1m 12s
check-linting (3.11)	28s
Unit Tests + PyArrow (Python 3.10, default deps)	57s
Unit Tests + PyArrow (Python 3.12, default deps)	58s
Unit Tests (Python 3.10, default deps)	33s
Unit Tests + PyArrow (Python 3.9, min deps)	1m 10s
Unit Tests (Python 3.10, min deps)	1m 0s
Unit Tests + PyArrow (Python 3.13, default deps)	1m 0s
Unit Tests (Python 3.11, default deps)	31s
Unit Tests + PyArrow (Python 3.11, min deps)	1m 10s
Unit Tests (Python 3.9, min deps)	55s
Unit Tests (Python 3.11, min deps)	59s
Unit Tests (Python 3.9, default deps)	28s
Unit Tests (Python 3.13, default deps)	33s
Unit Tests (Python 3.12, default deps)	30s
	19m 29s

Provide feedback