Piccolo

------

Improved ``refresh`` - it now works with prefetched objects. For example:

.. code-block:: python

>>> band = await Band.objects(Band.manager).first()
>>> band.manager.name
"Guido"

If the manager has changed in the database, when we refresh the band, the
manager object will also be updated:
>>> await band.refresh()
>>> band.manager.name
"New name"

Also, improved the error messages when creating a ``BaseUser`` - thanks to
haaavk for this.

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

------

Laying the foundations for alterative Postgres database drivers (e.g.
``psqlpy``). Thanks to insani7y and chandr-andr for their help with this.

.. warning::
The SQL generated by Piccolo changed slightly in this release. Aliases used
to be like ``"manager$name"`` but now they are like ``"manager.name"``
(note ``$`` changed to ``.``). If you are using ``SelectRaw`` in your queries
to refer to these columns, then they will need updating. Please let us know
if you encounter any other issues.

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

------

In Piccolo ``1.6.0`` we moved some aggregate functions to a new file. We now
re-export them from their original location to keep backwards compatibility.
Thanks to sarvesh-deserve for reporting this issue.

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

------

Improved ``LazyTableReference``, to help prevent circular import errors.

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

------

* Added documentation for one to one fields.
* Upgraded ASGI templates (thanks to sinisaos for this).
* Migrations can now be hardcoded as fake.
* Refactored tests to reduce boilerplate code.
* Updated documentation dependencies.

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

------

Added datetime functions, for example ``Year``:

.. code-block:: python

>>> from piccolo.query.functions import Year
>>> await Concert.select(Year(Concert.starts, alias="starts_year"))
[{'starts_year': 2024}]

Added the ``Concat`` function, for concatenating strings:

.. code-block:: python

>>> from piccolo.query.functions import Concat
>>> await Band.select(
... Concat(
... Band.name,
... '-',
... Band.manager._.name,
... alias="name_and_manager"
... )
... )
[{"name_and_manager": "Pythonistas-Guido"}]

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