Pybatis lets you use a templating engine to generate SQL in the same way we use templating engines to generate HTML. But while HTML is generated to send to a browser, Pybatis generates SQL to send to the database via Python's DB API, and then gathers the results. Pybatis consists of three things combined: Python's DB API, templates, and convenience methods. 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.
|Operating Systems||Linux Mac OS X Windows|
Release Notes: A bit of code refactoring. No new features.
Release Notes: Now you can select a single column to be returned as a list of scalars rather than a list of dicts (with each dict only having one key/value pair). For queries that return more than one column, you can name a column to be returned as a list of scalars.