Support for sqlAlchemy 2.0

[Bensebabillal]

Hi guys,

Con we add support for sql alchemy 2.0 please ?

Thank you

[amisadmin]

Yes, sqlalchemy 2.0 support will begin after pydantic V2 is released.

[honglei]

pydantic V2 is not needed for supporting sqlalchemy2.0:
migration to sqlalchemy 2.0

admin.py:
insfield.prop.secondary -> insfield.property.secondary

_sqlmodel.py:
stmt.with_only_columns([self.pk])->stmt.with_only_columns(self.pk)

[amisadmin]

pydantic V2 is not needed for supporting sqlalchemy2.0: migration to sqlalchemy 2.0

admin.py: insfield.prop.secondary -> insfield.property.secondary

_sqlmodel.py: stmt.with_only_columns([self.pk])->stmt.with_only_columns(self.pk)

Thank you for your feedback. I've been following the sqlmodel project.

[mikoda1995]

@amisadmin firstly thank you for this project. Do you have any plans to support sqlalchemy 2.0 now?

[peter65374]

it seems that sqlalchemy 2.0 was supported now. 👍

[mikoda1995]

it seems that sqlalchemy 2.0 was supported now. 👍

yep, but seems fastapi-user-auth is still depends on sqlmodel and fastapi-amis-admin<0.6.0