Piccolo

------

Made improvements to ``piccolo schema generate``, which automatically generates
Piccolo ``Table`` classes from an existing database.

There were situations where it would fail ungracefully when it couldn't parse
an index definition. It no longer crashes, and we print out the problematic
index definitions. See `PR 449 <https://github.com/piccolo-orm/piccolo/pull/449>`_.
Thanks to gmos for originally reporting this issue.

We also improved the error messages if schema generation fails for some reason
by letting the user know which table caused the error. Courtesy AliSayyah.

-------------------------------------------------------------------------------

------

We used to raise a ``ValueError`` if a column was both ``null=False`` and
``default=None``. This has now been removed, as there are situations where
it's valid for columns to be configured that way. Thanks to gmos for
suggesting this change.

-------------------------------------------------------------------------------

------

The ``where`` clause now raises a ``ValueError`` if a boolean value is
passed in by accident. This was possible in the following situation:

.. code-block:: python

await Band.select().where(Band.has_drummer is None)

Piccolo can't override the ``is`` operator because Python doesn't allow it,
so ``Band.has_drummer is None`` will always equal ``False``. Thanks to
trondhindenes for reporting this issue.

We've also put a lot of effort into improving documentation throughout the
project.

-------------------------------------------------------------------------------

------

* Lots of documentation improvements, including how to customise ``BaseUser``
(courtesy sinisaos).
* Fixed a bug with creating indexes when the column name clashes with a SQL
keyword (e.g. ``'order'``). See `Pr 433 <https://github.com/piccolo-orm/piccolo/pull/433>`_.
Thanks to wmshort for reporting this issue.
* Fixed an issue where some slots were incorrectly configured (courtesy
ariebovenberg). See `PR 426 <https://github.com/piccolo-orm/piccolo/pull/426>`_.

-------------------------------------------------------------------------------

------

Fixed a bug with auto migrations which rename columns - see
`PR 423 <https://github.com/piccolo-orm/piccolo/pull/423>`_. Thanks to
theelderbeever for reporting this, and sinisaos for help investigating.

-------------------------------------------------------------------------------

------

Added `Xpresso <https://xpresso-api.dev/>`_ as a supported ASGI framework when
using ``piccolo asgi new`` to generate a web app.

Thanks to sinisaos for adding this template, and adriangb for reviewing.

We also took this opportunity to update our FastAPI and BlackSheep ASGI
templates.

-------------------------------------------------------------------------------