Piccolo-api

------

Added ``token_login`` endpoint, which is more convenient than
``TokenAuthLoginEndpoint``.

Improved the docs for token auth and JWT auth (thanks to sinisaos).

Modified the ``OrderBy`` class, to add some functionality needed by Piccolo
Admin.

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

------

``PiccoloCRUD`` now lets you specify multiple columns in the ``__order`` GET
param.

For example, with this schema:

.. code-block:: python

class Movie(Table):
name = Varchar()
rating = Integer()

To order the results by descending ``rating`` and ascending ``name``:

.. code-block::

GET /?__order=-rating,name

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

------

You can now get all rows with a null / not-null value in ``PiccoloCRUD``.

For example, if we have a nullable column called ``score``:

.. code-block::

GET /?score__operator=is_null

Likewise, to get all rows whose score is not null:

.. code-block::

GET /?score__operator=not_null

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

------

Catching more database errors in ``PiccoloCRUD``, and returning useful API
responses instead of 500 errors.

Implemented GitHub's CodeQL suggestions - this now means ``LocalMediaStorage``
uses ``600`` instead of ``640`` as the default file permissions for uploaded
files (thanks to sinisaos for this).

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

------

* Added Python 3.11 support.
* ``PiccoloCRUD`` validators can now be async.
* Improved logging.
* The minimum version of FastAPI is now ``0.87.0``. The reason for this is
Starlette made a fairly large change in version ``0.21.0``, which meant we
had to refactor a lot of our tests, which makes it challenging to support
older versions.

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

------

Improving type annotations:

* Adding ``id: Serial`` for ``SessionsBase`` and ``TokenAuth``.
* Fixed type annotations for latest version of Starlette (thanks to sinisaos
for this).

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