Piccolo

------

Made improvements to the Piccolo playground.

* Syntax highlighting is now enabled.
* The example queries are now async (iPython supports top level await, so
this works fine).
* You can optionally use your own iPython configuration
``piccolo playground run --ipython_profile`` (for example if you want a
specific colour scheme, rather than the one we use by default).

Thanks to haffi96 for this. See `PR 656 <https://github.com/piccolo-orm/piccolo/pull/656>`_.

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

------

Fixed a bug with ``MyTable.objects().create()`` and columns which are not
nullable. Thanks to metakot for reporting this issue.

We used to use ``logging.getLogger(__file__)``, but as Drapersniper pointed
out, the Python docs recommend ``logging.getLogger(__name__)``, so it has been
changed.

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

------

* Fixed a bug with nullable ``JSON`` / ``JSONB`` columns and
``create_pydantic_model`` - thanks to eneacosta for this fix.
* Made the ``Time`` column type importable from ``piccolo.columns``.
* Python 3.11 is now supported.
* Postgres 9.6 is no longer officially supported, as it's end of life, but
Piccolo should continue to work with it just fine for now.
* Improved docs for transactions, added docs for the ``as_of`` clause in
CockroachDB (thanks to gnat for this), and added docs for
``add_raw_backwards``.

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

------

Added initial support for Cockroachdb (thanks to gnat for this massive
contribution).

Fixed Pylance warnings (thanks to MiguelGuthridge for this).

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

------

Added support for Starlite. If you use ``piccolo asgi new`` you'll see it as
an option for a router.

Thanks to sinisaos for adding this, and peterschutt for helping debug ASGI
mounting.

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

------

Fixed an edge case, where a migration could fail if:

* 5 or more tables were being created at once.
* They all contained foreign keys to each other, as shown below.

.. code-block:: python

class TableA(Table):
pass

class TableB(Table):
fk = ForeignKey(TableA)

class TableC(Table):
fk = ForeignKey(TableB)

class TableD(Table):
fk = ForeignKey(TableC)

class TableE(Table):
fk = ForeignKey(TableD)


Thanks to sumitsharansatsangi for reporting this issue.

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