If you use Python and you use SQL databases, you probably use SQLAlchemy. It's an ORM, it's a SQL DSL, it's extremely powerful and flexible. If you use a web app framework, you generally want to tie the lifecycle of your database transactions into the lifecycle of your HTTP request handling. Different web frameworks offer different approaches for this; if you use the Pyramid web framework, you hav