documentation of sqlalchemy version requirements

[lukengda]

I want to report that this project looks to be only compatible with sqlalchemy 2.x anymore --> README.md and requirements (in setup.py) seem to be outdated.

Here are my research results:

• As of commit aa58b86 ibmdbsa is only compatible with sqlalchemy >= 2
• Since release 0.4.0, ibmdbsa is only compatible with sqlalchemy >= 1.4

I am not in need of support for older versions of sqlalchemy, i would like to propose updating the requirments for the next person investigating this mismatch. Some code cleanup is possible if support for < 2 is officially dropped.

[bchoudhary6415]

Hi @lukengda ,

Thank you very much for your detailed research and feedback!

You’re right that starting from commit aa58b86 and release 0.4.0, ibmdbsa aimed for compatibility with SQLAlchemy >= 1.4, with some adjustments leaning toward SQLAlchemy 2.x.

However, with the latest PR #166
merged recently, the codebase now supports both SQLAlchemy versions < 2.0 and >= 2.0. This update was intended to maintain backward compatibility while preparing for SQLAlchemy 2.x standards.

We are planning to update the README and setup.py requirements accordingly to reflect this dual compatibility and clean up any outdated information.

Thanks again for raising this issue — your insights helped improve the project!

If you encounter any further problems or have suggestions, feel free to let us know.

Thank you!

[lukengda]

oh your right, my docs were older than that PR. Thank you for your response.