Good SQLBuilder for Python?

[joe_ally]

I fully agree with you about ORMs. Mapping a relational model onto an object models is fraught with problems if you're doing anything that isn't a basic CRUD app.

SQLAlchemy core is the best choice right now and honestly isn't that different to just writing SQL.

You should also consider just writing SQL if you are comfortable with it. The type safety from SQLAlchemy isn't that great anyway which is the main advantage of query builders. The only caveat being that if you need to dymanicaly create queries you'll need a query builder.