[backport 2.3.x] String dtype: enable in SQL IO + resolve all xfails (#60255) #20387

Job	Run time
Linux-32-bit	20m 30s
Linux-Musl	18m 11s
python-dev (macOS-13)	36m 55s
python-dev (macOS-14)	16m 51s
python-dev (ubuntu-22.04)	25m 12s
python-dev (windows-latest)	28m 26s
macos-13 actions-310.yaml	42m 45s
macos-13 actions-311.yaml	39m 47s
macos-13 actions-312.yaml	59m 41s
macos-13 actions-39.yaml	41m 9s
macos-14 actions-310.yaml	29m 46s
macos-14 actions-311.yaml	29m 9s
macos-14 actions-312.yaml	27m 47s
macos-14 actions-39.yaml	37m 24s
windows-latest actions-311.yaml	44m 12s
windows-latest actions-312.yaml	48m 17s
windows-latest actions-310.yaml	40m 34s
windows-latest actions-39.yaml	38m 36s
ubuntu-latest actions-310.yaml	59m 48s
Copy-on-Write 3.10	29m 8s
Copy-on-Write 3.10 (warnings)	28m 38s
ubuntu-latest actions-311.yaml	51m 3s
Future infer strings (without pyarrow)	53m 33s
Locale: zh_CN	29m 45s
Copy-on-Write 3.11	28m 58s
Copy-on-Write 3.11 (warnings)	28m 33s
Locale: it_IT	27m 8s
Numpy Dev	23m 14s
Pyarrow Nightly	25m 0s
Downstream Compat	6m 3s
Future infer strings	40m 25s
Copy-on-Write 3.12	33m 3s
ubuntu-latest actions-39.yaml	54m 41s
ubuntu-latest actions-312.yaml	42m 0s
Copy-on-Write 3.9 (warnings)	29m 34s
Copy-on-Write 3.9	29m 22s
Pypy	7m 31s
Minimum Versions	28m 36s
	21h 21m 15s

Provide feedback