Sqlalchemy-utils

^^^^^^^^^^^^^^^^^^^

- Fix breaking change introduced on SQLAlchemy 2.0.22 changes to `attributes.AttributeImpl` constructor (733)

^^^^^^^^^^^^^^^^^^^

- Use a custom SQL construct for refreshing materialized views in
`refresh_materialized_view` (703)

^^^^^^^^^^^^^^^^^^^

- Support psycopg3 for ``create_database()`` and ``delete_database()``.
(701, pull request by LerikP)

^^^^^^^^^^^^^^^^^^^

- Remove Python 3.6 support
- Add SQLAlchemy 2 support
- Add comparison operator support for LTree type (668, pull request by salimfadhley)

^^^^^^^^^^^^^^^^^^^

- Support Python 3.11.
- Add pre-commit hooks for uniform text checks, isort, flake8, and pyupgrade.
- Fix a crash that occurs if the ``colour-science`` package is installed,
which shares the same import name as the ``colour`` package that sqlalchemy-utils supports.
(`637 <https://github.com/kvesteri/sqlalchemy-utils/pull/637>`_, courtesy of JayPalm)
- Fix a crash that occurs if the installed sqlalchemy version is a beta (like ``"2.0.0b3"``).
(Reported in `643 <https://github.com/kvesteri/sqlalchemy-utils/pull/643>`_, thanks Dinmukhamet!)

^^^^^^^^^^^^^^^^^^^

- Fixed double-quoted UUID's in sqlalchemy >= 1.4.30 (581, pull request courtesy of kurtmckee)
- Fixed create_database() and drop_database() crashing with CockroachDB (586, pull request courtesy of kurtmckee)
- Added mixed case support for pg composite (584, pull request courtesy of bamartin125)
- Support Python 3.10.
- Drop support for Python 3.4 and 3.5.
- Remove the dependency on the six package. (605)
- Introduce sqlalchemy 2.0 compatibility. (513)