Having used sqlmodel recently for a project, I was underimpressed. Documentation was sparse, I found myself going to the source code to figure out how to solve problems I ran into, and I ended up dropping into sqlalchemy a lot more than I wanted. I think the idea is sound, but the code is hard to follow, and there are a lot of missing common cases.

I agree. It still needs a lot of work and is a far cry from ActiveRecord.

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.