BreezeBlocks

BreezeBlocks is a Python package for RDBMS-independent SQL generation. From Python objects representing the schema of a database, you can build and execute queries and other statements.

Compared to other packages that meet a similar need, BreezeBlocks follows more of an Active Statement model than and Active Record model. A SQL statement's representation has an execute method that will handle the details of getting a database connection and managing a transaction. The user should only need to be responsible for shaping the statement the way they want.

The source code is available on GitHub, the documentation is on Read the Docs, and it is available to download from PyPi.

flair