Piccolo

-----

Fixed a bug with nested array columns containing ``BigInt``. For example:

.. code-block:: python

class MyTable(Table):
my_column = Array(Array(BigInt))

Thanks to AmazingAkai for reporting this issue.

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

-----

Fixed a bug with foreign keys which reference ``BigSerial`` primary keys.
Thanks to Abdelhadi92 for reporting this issue.

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

-----

Added the ``piccolo user list`` command - a quick and convenient way of listing
Piccolo Admin users from the command line.

``ModelBuilder`` now creates timezone aware ``datetime`` objects for
``Timestamptz`` columns.

Updated the ASGI templates.

SQLite auto migrations are now allowed. We used to raise an exception, but
now we output a warning instead. While SQLite auto migrations aren't as feature
rich as Postgres, they work fine for simple use cases.

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

-----

Fixed a bug with filtering ``Array`` columns when choices are defined. Thanks
to sinisaos for discovering the solution.

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

-----

Fixed a bug with ``Array`` columns which have choices defined. Both a
``select`` and ``input`` widget were being shown.

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

-----

There's now an alternative syntax for joins, which works really well with
static type checkers like Mypy and Pylance.

The traditional syntax (which continues to work as before):

.. code-block:: python

Get the band name, and the manager's name from a related table
await Band.select(Band.name, Band.manager.name)

The alternative syntax is as follows:

.. code-block:: python

await Band.select(Band.name, Band.manager._.name)

Note how we use ``._.`` instead of ``.`` after a ``ForeignKey``.

This offers a considerably better static typing experience. In the above
example, type checkers know that ``Band.manager._.name`` refers to the ``name``
column on the ``Manager`` table. This means typos can be detected, and code
navigation is easier.

Other changes
~~~~~~~~~~~~~

* Improve static typing for ``get_related``.
* Added support for the ``esmerald`` ASGI framework.

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