New stuff

The query-builder has been rewritten from the ground-up to be more flexible andpowerful. There is now a generic, lower-level API forconstructing queries.

SQLite

Many SQLite-specific features have been moved from the playhouse.sqlite_extmodule into peewee, such as:

• User-defined functions, aggregates, collations, and table-functions.
• Loading extensions.
• Specifying pragmas.

See the “Using SQLite” section and “SQLite extensions”documents for more details.

SQLite Extension

The virtual-table implementation from sqlite-vtfunchas been folded into the peewee codebase.

• Support for SQLite online backup API.
• Murmurhash implementation has been corrected.
• Couple small quirks in the BM25 ranking code have been addressed.
• Numerous user-defined functions for hashing and ranking are now included.
• BloomFilter implementation.
• Incremental Blob I/O support.
• Support for update, commit and rollback hooks.
• LSMTable implementation to support the lsm1 extension.