Upgrade to support SQLAlchemy 2.x

[VickyTwig]

• liminal-orm pins sqlalchemy<2 (specifically 1.4.49)
• We have a dependency on sqlalchemy[asyncio]>=2.0.0: one of our packages declares fastapi-users[sqlalchemy]>=13.0.0,<14, which pulls fastapi-users-db-sqlalchemy 7.0.0, which hard-requires sqlalchemy[asyncio]>=2.0.0,<2.1.0. Auth/OAuth machinery mandates SQLAlchemy 2.x.
• Downgrading the package to SQLAlchemy 1.x would require also downgrading fastapi-users to ~10.x/11.x — a multi-major-version backstep of the auth library, with API changes around password hashing (pwdlib) and strategy interfaces.
• (Claude reassures me that) SQLAlchemy 1.4 → 2.0 is mostly mechanical for declarative-base usage like liminal's

Would it be possible to upgrade sqlalchemy to support SQLAlchemy 2.x?

Many thanks!

Vicky

[VickyTwig]

PS we've found a way around this so it's more of a nice to have for the future so low priority :)

[nirmit-damania-dyno]

Hey Vicky!

This is definitely on my radar, but currently blocked by my company (Dyno Tx) still being on SQLAlchemy 1.

I'm curious to learn about your work around, to share knowledge in case others are facing a similar issue!