For some of the apps I’ve developed (then proceeded to forget about), I’ve been writing plain SQL, primarily for MySQL. Though I have used ORMs in python like SQLAlchemy, I didn’t stick with them for long. Usually it was either the documentation or complexity (from my point of view) holding me back.
I see it like this: use an ORM for portability, plain SQL if it’s just going to be using one type of database. I’m really looking for advice on when to use an ORM or SQL when developing an app that needs database support.
Thinking about it, it would be far better to just use a lightweight wrapper to handle database inconsistencies vs. using an ORM.
