Pythons DB API + templates + convenience methods
Editor: Pybatis is three things combined: Pythons DB API + templates + convenience methods. The intent is to use a templating engine to generate SQL in the same way we use templating engines to generate HTML. Here, the similarities end. On the one hand, we generate HTML to send to a browser. With Pybatis, we generate SQL to send to the database via Pythons DB API, and gather our results.

The core idea of treating dynamic SQL as a templating problem rather than a code generation problem (as in most ORM libraries) comes from iBATIS, after which Pybatis is named, with great respect. you can free download Pybatis 1.5 now.