Fellow Python-Postgres web dev here. (Pyramid is my framework of choice, check it out!) I'm developing a web application that uses SQLAlchemy. The ORM has b

Fellow Python-Postgres web dev here. (Pyramid is my framework of choice, check it out!) I'm developing a web application that uses SQLAlchemy. The ORM has been a huge boon for CRUD functionality. We also have some very complicated reporting features and use SQLAlchemy's query builder almost exclusively. I find that the query builder maps very cleanly to SQL, so I can still "think" in SQL while writing and reading it. And the query builder makes complex query composition easier to manage.