Peewee

* Add changes required for building against Cython 3.0 and set Cython
language-level to 3.
* Ensure indexes aren't added to unindexed fields during introspection, 2691.
* Ensure we don't redundantly select same PK in prefetch when using
PREFETCH_TYPE.JOIN.
* In Sqlite migrator, use Sqlite's builtin DROP and RENAME column facilities
when possible. This can be overridden by passing `legacy=True` flag.

[View commits](https://github.com/coleifer/peewee/compare/3.16.0...3.16.1)

This release contains backwards-incompatible changes in the way Peewee
initializes connections to the underlying database driver. Previously, peewee
implemented autocommit semantics *on-top* of the existing DB-API transactional
workflow. Going forward, Peewee instead places the DB-API driver into
autocommit mode directly.

Why this change?

Previously, Peewee emulated autocommit behavior for top-level queries issued
outside of a transaction. This necessitated a number of checks which had to be
performed each time a query was executed, so as to ensure that we didn't end up
with uncommitted writes or, conversely, idle read transactions. By running the
underlying driver in autocommit mode, we can eliminate all these checks, since
we are already managing transactions ourselves.

Behaviorally, there should be no change -- Peewee will still treat top-level
queries outside of transactions as being autocommitted, while queries inside of
`atomic()` / `with db:` blocks are implicitly committed at the end of the
block, or rolled-back if an exception occurs.

**How might this affect me?**

* If you are using the underlying database connection or cursors, e.g. via
`Database.connection()` or `Database.cursor()`, your queries will now be
executed in autocommit mode.
* The `commit=` argument is deprecated for the `cursor()`, `execute()` and
`execute_sql()` methods.
* If you have a custom `Database` implementation (whether for a database that
is not officially supported, or for the purpose of overriding default
behaviors), you will want to ensure that your connections are opened in
autocommit mode.

Other changes:

* Some fixes to help with packaging in Python 3.11.
* MySQL `get_columns()` implementation now returns columns in their declared
order.

[View commits](https://github.com/coleifer/peewee/compare/3.15.4...3.16.0)

* Raise an exception in `ReconnectMixin` if connection is lost while inside a
transaction (if the transaction was interrupted presumably some changes were
lost and explicit intervention is needed).
* Add `db.Model` property to reduce boilerplate.
* Add support for running `prefetch()` queries with joins instead of subqueries
(this helps overcome a MySQL limitation about applying LIMITs to a subquery).
* Add SQL `AVG` to whitelist to avoid coercing by default.
* Allow arbitrary keywords in metaclass constructor, 2627
* Add a `pyproject.toml` to silence warnings from newer pips when `wheel`
package is not available.

This release has a small helper for reducing boilerplate in some cases by
exposing a base model class as an attribute of the database instance.

python
old:
db = SqliteDatabase('...')

class BaseModel(Model):
class Meta:
database = db

class MyModel(BaseModel):
pass

new:
db = SqliteDatabase('...')

class MyModel(db.Model):
pass


[View commits](https://github.com/coleifer/peewee/compare/3.15.3...3.15.4)

* Add `scalars()` query method (complements `scalar()`), roughly equivalent to
writing `[t[0] for t in query.tuples()]`.
* Small doc improvements
* Fix and remove some flaky test assertions with Sqlite INSERT + RETURNING.
* Fix innocuous failing Sqlite test on big-endian machines.

[View commits](https://github.com/coleifer/peewee/compare/3.15.2...3.15.3)

* Fix bug where field-specific conversions were being applied to the pattern
used for LIKE / ILIKE operations. Refs 2609
* Fix possible infinite loop when accidentally invoking the `__iter__` method
on certain `Column` subclasses. Refs 2606
* Add new helper for specifying which Model a particular selected column-like
should be bound to, in queries with joins that select from multiple sources.

[View commits](https://github.com/coleifer/peewee/compare/3.15.1...3.15.2)

* Fix issue introduced in Sqlite 3.39.0 regarding the propagation of column
subtypes in subqueries.
* Fix bug where cockroachdb server version was not set when beginning a
transaction on an unopened database.

[View commits](https://github.com/coleifer/peewee/compare/3.15.0...3.15.1)