Unpin pandas

[dhirschfeld]

I would like to be able to use this library with the latest pandas version. Currently pandas is pinned to <2.2.0:

databricks-sql-python/pyproject.toml

Lines 14 to 16 in 0552990

	pandas = [
	{ version = ">=1.2.5,<2.2.0", python = ">=3.8" }
	]

It would be good to remove this restriction.

[dhirschfeld]

The pin was added in:

• Update pyproject.toml to fix issues seen in dbt-databricks #330

To fix the issue described in:

• TypeError: int() argument must be a string, a bytes-like object or a number, not 'NoneType' #326

...but that just avoids the problem whilst causing another problem; this library can't be used with the latest pandas :/

[dhirschfeld]

I'm opening this issue to track any progress towards compatibility with the latest pandas version.

[dhirschfeld]

Bump! I would like to upgrade to the latest version but am stuck on 3.0.1 because of this pin 😔

[benc-db]

Does 3.0.1 work with latest pandas? That would be an interesting data point.