Piccolo

-----

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).

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

-----

On the add row and edit row forms, the save button is now temporarily disabled
after being pressed (until the API call finishes). This is to prevent a user
from accidentally clicking the button multiple times. Thanks to sinisaos for
helping with this.

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

-----

Improved how ``ModelBuilder`` handles recursive foreign keys.

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

-----

Fixed an edge case with auto migrations.

If starting from a table like this, with a custom primary key column:

.. code-block:: python

class MyTable(Table):
id = UUID(primary_key=True)

When a foreign key is added to the table which references itself:

.. code-block:: python

class MyTable(Table):
id = UUID(primary_key=True)
fk = ForeignKey("self")

The auto migrations could fail in some situations.

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