Will the project be updated with SQLAlchemy version 2.0?

[cfraboulet]

First Check

• I added a very descriptive title here.
• I used the GitHub search to find a similar question and didn't find it.
• I searched the SQLModel documentation, with the integrated search.
• I already searched in Google "How to X in SQLModel" and didn't find any information.
• I already read and followed all the tutorial in the docs and didn't find an answer.
• I already checked if it is not related to SQLModel but to Pydantic.
• I already checked if it is not related to SQLModel but to SQLAlchemy.

Commit to Help

• I commit to help with one of those options 👆

Example Code

[tool.poetry]
name = "sqlmodel"
version = "0"
description = "SQLModel, SQL databases in Python, designed for simplicity, compatibility, and robustness."
authors = ["Sebastián Ramírez <tiangolo@gmail.com>"]
readme = "README.md"
homepage = "https://github.com/tiangolo/sqlmodel"
documentation = "https://sqlmodel.tiangolo.com"
repository = "https://github.com/tiangolo/sqlmodel"
license = "MIT"
exclude = ["sqlmodel/sql/expression.py.jinja2"]
classifiers = [
    "Development Status :: 4 - Beta",
    "Framework :: AsyncIO",
    "Intended Audience :: Developers",
    "Intended Audience :: Science/Research",
    "Intended Audience :: System Administrators",
    "License :: OSI Approved :: MIT License",
    "Programming Language :: Python :: 3 :: Only",
    "Programming Language :: Python :: 3.6",
    "Programming Language :: Python :: 3.7",
    "Programming Language :: Python :: 3.8",
    "Programming Language :: Python :: 3.9",
    "Topic :: Database",
    "Topic :: Database :: Database Engines/Servers",
    "Topic :: Internet",
    "Topic :: Internet :: WWW/HTTP :: HTTP Servers",
    "Topic :: Internet :: WWW/HTTP",
    "Typing :: Typed",
]

[tool.poetry.dependencies]
python = "^3.6.1"
SQLAlchemy = ">=1.4.17,<=1.4.41"
pydantic = "^1.8.2"
sqlalchemy2-stubs = {version = "*", allow-prereleases = true}

Description

Using FastAPI and SQLModel in my projects, I was wondering if the SQLAlchemy package used in SQLModel was going to be updated to the latest version 2.0.0 which was released on 26 January 2023 in order to use the latest features?

Thank you very much for your feedback.

Operating System

Linux

Operating System Details

Fedora Linux 36

SQLModel Version

0.0.8

Python Version

3.9.14

Additional Context

No response

[tiangolo]

Yes, it will. But there are other things I have to update do first.

SQLModel 0.0.14 now has support for Pydantic v2, and it also keeps support for Pydantic v1. 🎉

[antont]

@arogozhnikov did you come to a conclusion there?

I like how seamless the fastapi-sqlalchemy integration is with sqlmodel, but is sure cool how SA 2.0 Mapped and dataclasses support similar things.

[arogozhnikov]

I've moved to sqlalchemy2. If you're interested in my personal experience (with pros and cons), I've completely described it here: sqlalchemy/sqlalchemy#9394

[antont]

sqlalchemy/sqlalchemy#9394

Cool, thanks a lot. Are you using FastAPI also?

[arogozhnikov]

just a bit. It is not the main interface for me

[tiangolo]

SQLModel 0.0.14 now has support for Pydantic v2, and it also keeps support for Pydantic v1. 🎉

[oliviernguyenquoc]

Tried to use SQLALchemy 2.0 without SQLModel (without writing both models and pydantic schemas) in Declerative Mapping style, and it turns out that it's not possible for edge cases.

More info: sqlalchemy/sqlalchemy#10027

So, IMO SQLModel have still a role to play in a SQLAlchemy 2.0 context

[antont]

To me SQLModel also looks useful in how straightforward and clear it makes the basics.

Also, it's small, the main.py being just 655 lines, so I'm also not surprised if it remains a useful glue.

I haven't tried that alternative approach myself though, have only taken a look a couple of times.

[8thgencore]

There is no information about migrating to SQLAlchemy 2.0 and Pydantic v2.

[martinralfreindl]

Any updates on this? Would love to FastAPI + SQLModel, but our entire code base is in SQLAlchemy 2.0, so switching isn't possible for us at the moment.

[ahaly-compass]

Seems that fastapi and SQLModel are supporting Pydantic2 now.
Is there still a plan to user SQLAlchemy 2.0 in SQLModel?

[antont]

Seems that fastapi and SQLModel are supporting Pydantic2 now. Is there still a plan to user SQLAlchemy 2.0 in SQLModel?

That was done right before Pydantic2, is out since 0.0.12

✨ Upgrade SQLAlchemy to 2.0. PR #700 by @tiangolo including initial work in PR #563 by @farahats9.

https://github.com/tiangolo/sqlmodel/releases