- Added cross-database support for
NULLS FIRST/LAST
when specifying the ordering for a query. Previously this was only supported for Postgres. Peewee will now generate an equivalentCASE
statement for Sqlite and MySQL. - Added EXCLUDED helper for referring to the
EXCLUDED
namespace used withINSERT...ON CONFLICT
queries, when referencing values in the conflicting row data. - Added helper method to the model
Metadata
class for setting the table name at run-time. Setting theModel._meta.table_name
directly may have appeared to work in some situations, but could lead to subtle bugs. The new API isModel._meta.set_table_name()
. - Enhanced helpers for working with Peewee interactively, see doc.
- Fix cache invalidation bug in
DataSet
that was originally reported on the sqlite-web project. - New example script implementing a hexastore.