SQLAlchemy 2.0

Hello,

We would like to move our project to SQLAlchemy 2.0, due to it supporting the new oracledb package as well as Mapped annotation, which significantly simplifies our model definition and usage.

From a brief view into SQLAlchemy usage in Rasa, it seems to be very minimal, and the constraint on SQLAlchemy can be relaxed to support 2.0.x without much worry. Although, going through their migration guide and process would give a more definitive answer.

Thank you,

Are you asking about use of 2.0 for the action server or tracker store?

We use Rasa as a dependency to a larger project, and within that project, we have our own SQLAlchemy models and queries. That’s where we would like to use SQLAlchemy 2.0.

That’s to say, Rasa pinning SQLAlchemy to <2.0 is our limiting factor.

I don’t see an open Jira item on this so you should submit one. Described here.