Piccolo

------

Added ``not_any`` method for ``Array`` columns. This will return rows where an
array doesn't contain the given value. For example:

.. code-block:: python

class MyTable(Table):
array_column = Array(Integer())

>>> await MyTable.select(
... MyTable.array_column
... ).where(
... MyTable.array_column.not_any(1)
... )
[{"array_column": [4, 5, 6]}]

Also fixed a bunch of Pylance linter warnings across the codebase.

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

-----

Fixed some bugs with optional fields in custom forms (thanks to Skelmis for
reporting this).

Improved the contribution docs (thanks to Skelmis for this).

Improved the MFA docs (thanks to sinisaos for this).

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

-----

Added some math functions, for example ``Abs``, ``Ceil``, ``Floor`` and
``Round``.

.. code-block:: python

>>> from piccolo.query.functions import Round
>>> await Ticket.select(Round(Ticket.price, alias="price"))
[{'price': 50.0}]

Added more operators to ``QueryString`` (multiply, divide, modulus, power), so
we can do things like:

.. code-block:: python

>>> await Ticket.select(Round(Ticket.price) * 2)
[{'price': 100.0}]

Fixed some edge cases around defaults for ``Array`` columns.

.. code-block:: python

def get_default():
This used to fail:
return [datetime.time(hour=8, minute=0)]

class MyTable(Table):
times = Array(Time(), default=get_default)

Fixed some deprecation warnings, and improved CockroachDB array tests.

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

-----

Added a missing JPEG file for an example form.

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

-----

Added more example forms.

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

-----

Added the ``Cast`` function, for performing type conversion.

Here's an example, where we convert a ``timestamp`` to ``time``:

.. code-block:: python

>>> from piccolo.columns import Time
>>> from piccolo.query.functions import Cast

>>> await Concert.select(Cast(Concert.starts, Time()))
[{'starts': datetime.time(19, 0)}]

A new section was also added to the docs describing functions in more detail.

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