@dan Turns out I do want the mapping though, warts and all. =)
SQLAlchemy on Python has enough knobs and dials to overcome the worst of the impedance mismatch, "in particular the 'n loads' problem", and it has a nice clean layer between ORM and SQL abstraction for when you really need to get in there.
The abstraction leaks but is mostly helpful.