Upgrade to support pydantic 2.0+

[jessereich-mcs]

Currently pinned to pydantic<2.0.0 but pydantic 2.0 has been out for a few months.

[parikls]

+1 for this

[ss1917]

+1 for this

[yanghongfei]

+1 for this

[ops-coffee]

+1 for this

[cyancow]

+1 for this

[wezhai]

If you are using pydantic v2 and sqlalchemy 2.0 and above, try this sqlalchemy-to-pydantic

[jamesbraza]

For those looking for a link to the source code behind sqlalchemy-to-pydantic, it's here: https://github.com/wezhai/sqlalchemy-to-pydantic. Linking sqlalchemy-to-pydantic's source to PyPI was requested in https://github.com/wezhai/sqlalchemy-to-pydantic/issues/1

[realazizk]

@wezhai that requires sqlalchemy 2 🤔

[realazizk]

this make from_orm work again https://github.com/mohamed-aziz/pydantic-sqlalchemy/commit/4b1821c418014e26c53449a3800beba318c130f3