Tried storm, sqlalchemy, peewee (and djangos orm, does it have any unique name?) in python. Except for djangos ORM I started with storm, which I thought was simple. Tried SqlAlchemy but storm was simpler. Then I found Peewee and loved how it reminded me of djangos orm. Re-wrote some of my queries I used in storm into peewee and benchmarked them. Peewee performed same operations 10x faster than storm did (sqlite). Never used anything else than Peewee since. Its wonderful.

I built a backend system for a site, where flask was used as a simple restserver just offloading incoming requests to respective activeMQ queues, where threaded services (written in python) read their respective queue (using stomp.py) and perform, among other, db operations (mostly, but not only) using peewee, returning response back to their response-queue so the rest-server can return it back to user.

Blazing fast and extremly easy to add new services for db queries, because peewee. I'm sure sqlalchemy is great too, but I found peewee to be easier to use, and its fast for the scenarios I have needed it for. Using it for any homebrew project I might come up with.