feat: Add multi-statement transaction support #2608

Job	Run time
Unit Tests + PyArrow (Python 3.9, default deps)	56s
Unit Tests + PyArrow (Python 3.11, default deps)	57s
Unit Tests + PyArrow (Python 3.10, default deps)	1m 8s
Unit Tests + PyArrow (Python 3.10, min deps)	1m 20s
Unit Tests + PyArrow (Python 3.9, min deps)	1m 13s
Unit Tests (Python 3.10, default deps)	34s
Unit Tests (Python 3.13, default deps)	34s
check-linting (3.10)	35s
check-types (3.12)	35s
Unit Tests (Python 3.10, min deps)	58s
Unit Tests (Python 3.11, default deps)	27s
check-linting (3.12)	27s
check-linting (3.13)	28s
Unit Tests + PyArrow (Python 3.13, default deps)	1m 14s
check-types (3.10)	39s
check-types (3.11)	32s
Unit Tests (Python 3.9, default deps)	35s
Unit Tests (Python 3.11, min deps)	51s
Unit Tests (Python 3.9, min deps)	52s
Unit Tests + PyArrow (Python 3.12, default deps)	58s
Unit Tests + PyArrow (Python 3.11, min deps)	1m 23s
check-linting (3.11)	27s
check-linting (3.9)	31s
check-types (3.9)	34s
check-types (3.13)	38s
Unit Tests (Python 3.12, default deps)	39s
	20m 5s

Provide feedback