Actually Pydantic could be extremely useful if used in conjunction with SQLAlchemy, check out the SQLModel library, from the very same creators of Pydantic.
I've been working on a wrapper around it to make it more usable, hoping to get as much of the work merged upstream into SQLModel:
https://github.com/iloveitaly/activemodel
Unfortunately, I just don't see a better option than SQLModel for ORM at this point.
While it uses pydantic, sqlmodel has not been written by those guys