> It's about the rows and objects, moving the data from the objects to the INSERT statement, moving the data from the rows you SELECTed back to the objects. Not to mention abstraction
That's actually the problem.
I'm sure you're aware that ORMs have this fundamental problem called the ORM impedance mismatch problem. AFAIK it remains unsolved to this day.
> You can use SQLAlchemy (which I wrote) and write all the SQL 100% yourself as literal strings
This is true, but it's like saying you can disassemble a Boeing 737 to build chopsticks. It's true but completely unnecessary.
That's actually the problem.
I'm sure you're aware that ORMs have this fundamental problem called the ORM impedance mismatch problem. AFAIK it remains unsolved to this day.
> You can use SQLAlchemy (which I wrote) and write all the SQL 100% yourself as literal strings
This is true, but it's like saying you can disassemble a Boeing 737 to build chopsticks. It's true but completely unnecessary.