Risclog.sqlalchemy

================

- Nothing changed yet.

================

- Fix `sqlalchemy` 1.3 compatibility in `Database.empty()`.

================

- Introduce new `RoutingSession` method `execute_with_bind()` to execute
statements with a specific bind.
- `RoutingSession.using_bind()` is now deprecated and kept for backward
compatibility.
Instead of a new session instance, it now returns a shim that maps a
minimal subset of session methods to the original session instance.
This change was necessary because the previous implementation of creating
a new session instance and copying all the original session's state
proved unstable when used with SQLAlchemy 1.4. (One reason being the new
autobegin feature of sessions changing interactions with `zope.sqlalchemy`.)

================

- Add json encoder for `uuid.UUID` objects.

- Add `risclog.sqlalchemy.interfaces.Deleted` event which is fired when an
object is deleted from the database.

================

- Introduce `ModelCache` that reduces the number of DB requests when dealing
with huge amounts of sqlalchemy models.

- Allow specifying `keep_session` and `expire_on_commit`.

- Drop support for Python 3.6.

- Drop support for SQLAlchemy 1.0 and 1.1.

- Add support for Python 3.10 and 3.11.

- Restrict supported SQLALchemy to < 2.

================

Features
--------

- Ensure compatibility with ``SQLAlchemy >= 1.4``.

Other changes
-------------

- Use github actions as CI.