🚀 Roadmap

[tiangolo]

🚀 Roadmap

[tjeaneric]

Now Ready for Pydantic 2.0 🚀

Update: Since SQLModel version 0.0.14, both Pydantic V1 and v2 are now supported 🚀🚀

[benjipott]

• Support for SQLAlchemy 2.0.

[Zaffer]

This is great news! So excited to start using these new features. I'm curious how you are planning in integrating Alembic?

[joshTax]

You can help me ensure each existing PR is in shape (has tests, solves the problem, etc.)

🫡

So glad to see signs of life in this amazing project.

[zoonman]

I am looking forward for SQLAlchemy v2 support. This should enable ClickHouse columnar storage.

[linpan]

Integrated migrations (using Alembic).

[luoshuijs]

Since the dev dependency, FastAPI, no longer supports Python 3.7 from version 0.104.0 onwards, will SQLModel also need to drop support for Python 3.7 in the future? If so, it would likely be a massive undertaking. It should be included in the roadmap together.

Pydantic and SQLAlchemy have already dropped support for Python 3.7.

pydantic/pydantic@0564c0d
sqlalchemy/sqlalchemy@4da59c6

Additionally, Python 3.7 reached its End of Life (EOL) a few months ago, so it's time to say goodbye.

https://devguide.python.org/versions/

Some things that may need to be done

• ⬆️ Drop Support for Python 3.7
• ⬆️ Upgrade Python version in Docker images for GitHub Actions

[fabifont]

Hi @tiangolo, are #689 and #635 ready to be merged?

[hyperknot]

Is there a branch of this project or a starter template for using FastAPI latest + SQLAlchemy 2 + Pydantic 2?

I'm starting a new project with FastAPI latest + SQLAlchemy 2 and I'm not sure what would be the right way to set it up? Should I just avoid SQLModel altogether?

[KelvinSan]

Are we going to get an update on the Async docs ?

[linpan]

Hi @tiangolo, are #689 and #635 ready to be merged?

[hyperknot]

Thanks @honglei.

I've also found

• https://chaoticengineer.hashnode.dev/fastapi-sqlalchemy and
• https://github.com/rhoboro/async-fastapi-sqlalchemy

I'll personally not use SQLModel. It introduces way too much logic for a simple type checking functionality for me.

Duplicating a small amount of code in the codebase is much more maintainable than introducing an external dependency with a lot of logic involved.

[dimaqq]

I'm curious what are the tricky parts in SQLAlchemy and pydantic 2.0.0 versions...

[cay89]

@tiangolo Could you please provide any updates on this? I've begun a new FastAPI project, and I'm uncertain whether I should build upon the SQLModel project or stay with SQLAlchemy. What are your long term plans with this project?

[caerulescens]

@cay89 This and the cookiecutter template are under development; from @tjeaneric, it looks like the sqlalchemy and pydantic support is done, but the alembic support hasn't been released yet.

You should be able to use sqlmodel==0.0.14 and manually generate migrations for your fastapi project: alembic init --template async alembic. You will need to manually edit the generated alembic.ini and alembic/env.py to use sqlmodel's metadata object. This was possible in 0.0.8 before the sqlalchemy relationship support broke around sqlalchemy==1.4.x. Things are still sort of in limbo for official design patterns when considering a backend stack consisting of fastapi, sqlalchemy, pydantic, and alembic. This integration has been tracking between the authors of these projects for more than a few years. The official design patterns for backend work are right around the corner.

[caerulescens]

@manish181192 I haven't seen an "ETA"; some of the remaining work is staged as PRs:

• #689
• #512
• #635

---

I haven't seen any work covering typer usage in sqlmodel.

[AntonDeMeester]

Is the goal to support both Pydantic v1 and v2 and SQL Alchemy v1 and v2? Or only v1+v1 and v2+v2? The combination of both will become difficult.

[chamithdulshanadl]

We are using fast API with SQL Model for our microservices. And planning to add Llama index which needs SQLAlchemy above 1.4.41. But does not support by current SQL Model versions (required: >=1.4.17,<=1.4.41).

@tiangolo Need your kind help.

[nikdavis]

Sorry if this is adding noise – just noticing the next items in the roadmap are somewhat achieved in #632 (open since August). Any chance we could understand the project's thinking wrt when something like that might be merged or reworked?

[manish181192]

Hello team, Amazing work, What is the ETA on Async milestone? Can we bump it up before pydantic? @tiangolo

[gmos]

Fully agree. Have other stuff already upgraded to pydantic 2.x.x and SqlAlchemy 2.x.x and cannot introduce SQLModel to the mix. From: Matthieu LAURENT ***@***.***> Sent: Tuesday, 24 October 2023 15:21 To: tiangolo/sqlmodel ***@***.***> Cc: Subscribed ***@***.***> Subject: Re: [tiangolo/sqlmodel] 🚀 Roadmap (Issue #654) Are the items on the roadmaps features you plan to implement yourself, or are they open for PRs? In any case, this is really exciting! I can't wait to be able to use a Pydantic v2 + SQLModel (with all the great SQLAlchemy 2 features) + FastAPI stack! — Reply to this email directly, view it on GitHub<#654 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/AALUWECMEPO3K523RRZFZ3DYA66DLAVCNFSM6AAAAAA5TK2VBOVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZXGE4TEOJRGE>. You are receiving this because you are subscribed to this thread.Message ID: ***@***.******@***.***>>

[luoshuijs]

Since the dev dependency, FastAPI, no longer supports Python 3.7 from version 0.104.0 onwards, will SQLModel also need to drop support for Python 3.7 in the future? If so, it would likely be a massive undertaking. It should be included in the roadmap together.

[AAraKKe]

Hi! I just came across #63 and I was surprised this would not work out of the box, is this kind of behaviour considered at any stage on the roadmap?

Kind of related is #468 , I have it almost sorted out setting the engine with json serializer and deserializer but now I just noticed that if I change a field in the model the update woin't go through when committing.

Thanks!

[caerulescens]

Take a look at this.

[honglei]

@AntonDeMeester @tiangolo Only support SQLAlchemy v1.4 with 2.0-style and v2.0?

[honglei]

@hyperknot Try #632

[Matthieu-LAURENT39]

Are the items on the roadmaps features you plan to implement yourself, or are they open for PRs?

In any case, this is really exciting! I can't wait to be able to use a Pydantic v2 + SQLModel (with all the great SQLAlchemy 2 features) + FastAPI stack!

[Leewinner1]

When dealing with relational models,sqlalchemy only needs to define relationships on one side,sqlmodel needs to define relationships on both sides, and the complexity of the model class is very difficult to deal with. The screen full of relationships makes my brain a little hot, especially the many-to-many relationships, even if the model class is written according to the documentation, it becomes extremely complex.