feat: Add multi-statement transaction support #2606

Job	Run time
Unit Tests (Python 3.10, default deps)	45s
Unit Tests (Python 3.9, min deps)	58s
Unit Tests (Python 3.9, default deps)	45s
Unit Tests (Python 3.10, min deps)	1m 3s
Unit Tests (Python 3.11, min deps)	1m 8s
check-linting (3.9)	43s
check-linting (3.13)	33s
Unit Tests (Python 3.12, default deps)	44s
Unit Tests (Python 3.11, default deps)	45s
Unit Tests + PyArrow (Python 3.9, default deps)	1m 3s
check-linting (3.12)	47s
check-linting (3.10)	43s
Unit Tests (Python 3.13, default deps)	44s
Unit Tests + PyArrow (Python 3.10, default deps)	1m 8s
Unit Tests + PyArrow (Python 3.11, min deps)	1m 12s
Unit Tests + PyArrow (Python 3.9, min deps)	1m 17s
check-types (3.11)	45s
Unit Tests + PyArrow (Python 3.12, default deps)	1m 4s
check-types (3.12)	45s
check-linting (3.11)	36s
check-types (3.13)	48s
Unit Tests + PyArrow (Python 3.11, default deps)	59s
check-types (3.10)	49s
check-types (3.9)	1m 0s
Unit Tests + PyArrow (Python 3.13, default deps)	1m 9s
Unit Tests + PyArrow (Python 3.10, min deps)	1m 16s
	23m 29s

Provide feedback