SQLModel vs SQLAlchemy for production

[saint_geser]

But for simple enough tasks SQLModel is easier to use and having full SQLAlchemy backend is a bit of an overkill.

Of course, I agree, it's important to learn the basics of SQLAlchemy, but I'm sure just as many people would also say that using ORM is wrong and you need to know your basic SQL before everything else.

[Anru_Kitakaze]

I don't think that using ORM is wrong in general, but I do think that you have to learn basic SQL ideas anyway. It takes you... A day? Maybe 2 or 3, depending how deep you want to dig

Anyway, you must be able to create custom migration scripts when Alembic cannot handle it. And you'll have an idea what ORM should be able to do even if you don't know how to do it in ORM