search

exasol / sqlalchemy-exasol

SQLAlchemy dialect for EXASOL
https://exasol.github.io/sqlalchemy-exasol/
Other
34 stars 28 forks source link

Support SQLAlchemy 2 #413

Open bmritz opened 9 months ago

bmritz commented 9 months ago

Summary

Support SqlAlchemy version 2.X as a dependency.

Details

I'd like to be able to use the latest versions of SQLAlchemy with sqlalchemy-exasol.

Background & Context

Currently, when Installing sqlalchemy-exasol in an environment where there are other sqlalchemy tools, this library prevents the user from using the latest version of SQLAlchemy.

References

https://docs.sqlalchemy.org/en/20/changelog/whatsnew_20.html#

Nicoretti commented 9 months ago

Hi @bmritz,

Thanks for raising this issue! Internally, we've initiated discussions with our project management team regarding including this in our roadmap. We'll keep this issue updated as we make progress on the SQLAlchemy2 upgrade.

Lastly, I have a quick question: Are you planning to upgrade all code to SQLAlchemy2 once it's available, or are there systems/codes of yours that still will rely on 1.4.x?

Best, Nico

bmritz commented 9 months ago

Thanks Nicola -- good to hear there's already some discussion! With this update we'd be set to upgrade everything in our monorepo to SQLAlchemy 2. We're on 1.4.X right now, and it appears that it still is supported by the SQLAlchemy team, and receives bugfixes, so it's not a huge issue for use now, but I anticipate it will become one at some point in the future. Thanks for the reply!

On Thu, Nov 30, 2023 at 2:24 AM Nicola Coretti @.***> wrote:

Hi @bmritz https://github.com/bmritz,

Thanks for raising this issue! Internally, we've initiated discussions with our project management team regarding including this in our roadmap. We'll keep this issue updated as we make progress on the SQLAlchemy2 upgrade.

Lastly, I have a quick question: Are you planning to upgrade all code to SQLAlchemy2 once it's available, or are there systems/codes of yours that still will rely on 1.4.x?

Best, Nico

— Reply to this email directly, view it on GitHub https://github.com/exasol/sqlalchemy-exasol/issues/413#issuecomment-1833236084, or unsubscribe https://github.com/notifications/unsubscribe-auth/AB3KKG7MGFGHWGRGSAYK64DYHAYDZAVCNFSM6AAAAAA77V3236VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMZTGIZTMMBYGQ . You are receiving this because you were mentioned.Message ID: @.***>

Nicoretti commented 7 months ago

Note: To simplify the project's SQLA2 migration/support, deprecated dialects should be dropped first: