I also can vouch for SQLAlchemy, in the in the sense that it allows me to write SQL with confidence, where the code matches the query.