The current setup.py fixes the sqlalchemy requirement at 1.4.29, though for versions of pandas ≥2.2.0 (which is not restricted in setup.py), this will result in some adapter dependents no longer working.
It seems to make sense to commit to having dependents of adapter become compatible with pandas ≥2.2.0, and then commit to updating adapter to require pandas≥2.2.0 and newer sqlalchemy.
Related to this issue, which is a matter of newer versions of pandas requiring newer versions of openpyxl.
The current
setup.pyfixes the sqlalchemy requirement at1.4.29, though for versions of pandas≥2.2.0(which is not restricted in setup.py), this will result in some adapter dependents no longer working.It seems to make sense to commit to having dependents of adapter become compatible with pandas ≥2.2.0, and then commit to updating adapter to require pandas≥2.2.0 and newer sqlalchemy.
Related to this issue, which is a matter of newer versions of pandas requiring newer versions of openpyxl.