StackedObjectProxy (which I have mixed feelings about), data mapper pattern (basically SQLAlchemy kicking ass), and the kicker: an integrated debugger.
There are others I've noticed, but that's off the top of my head. Of course, Pylons falls short in some other areas.