Piccolo

-----

Make the `MFA Setup` URL relative, so it works when Piccolo Admin isn't mounted
at the root.

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

-----

Arrays of ``Date`` / ``Time`` / ``Timestamp`` / ``Timestamptz`` now work in
SQLite.

For example:

.. code-block:: python

class MyTable(Table):
times = Array(Time())
dates = Array(Date())
timestamps = Array(Timestamp())
timestamps_tz = Array(Timestamptz())

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

-----

Added support for a bunch of Postgres functions, like ``Upper``, ``Lower``,
``Length``, and ``Ltrim``. They can be used in ``select`` queries:

.. code-block:: python

from piccolo.query.functions.string import Upper
>>> await Band.select(Upper(Band.name, alias="name"))
[{"name": "PYTHONISTAS"}]

And also in ``where`` clauses:

.. code-block:: python

>>> await Band.select().where(Upper(Band.manager.name) == 'GUIDO')
[{"name": "Pythonistas"}]

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

-----

Added an ``Album`` table to the playground, along with some other
improvements.

Fixed a bug with the ``output(load_json=True)`` clause, when used on joined
tables.

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

-----

Fixed a bug with the CLI when reversing migrations (thanks to metakot for
reporting this).

Updated the ASGI templates (thanks to tarsil for adding Lilya).

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

-----

Lots of internal improvements, mostly to support new functionality in Piccolo
Admin.

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