Hi folks, I'm new to prefect. I've just written my SQLAlchemy models, hoping to query them from a

@task

, but I wrote the models using SQLAlchemy v2, and it looks like Prefect depends on v1.4. Is it not possible to use the latest SQLAlchemy version for my models with Prefect?

see https://github.com/PrefectHQ/prefect/issues/8052

Thanks @redsquare I did see that, but assume dit was about upgrading Prefect's codebase to use SQLAlchemy v2. My question was whether I was limited to v1.4 in my workflow files, which I appreciate may be obvious to someone who's done more work in Python (it's been a while for me!)

ok sure - not tried it myself as yet

If you’re running the server elsewhere or using Prefect Cloud you can use a newer version of SQLAlchemy

Thanks Zanie. I haven't gotten to the point of deploying yet, so I don't quite understand how I could "run the server elsewhere" - I'll dig in to the docs on those concepts in a bit. For now, I've translated my model over to sqlalchemy v1.4 - thanks for clarifying though!

👍 we run the API in-memory whenever you run a flow without setting an API URL