[gigatexal]

With a few extra lines and mapping objects to classes this can be done.

To have all this ease of use you give up so much in performance.

Most apps and companies never get to the point where performance matters that’s why we have ORMs.

[mekoka]

> you give up so much in performance.

Not really. ORMs (memory) and databases (disk) are distant by multiple orders of magnitude performance wise. Skipping the ORM to shave off some cycles is akin to haggling over a few pennies on your thousand dollars bill.

[gigatexal]

SQLAlchemy vs hand rolled SQL and mapping the results it’s not even close. The overhead if you need it cuz you’re sub scale so be it.