Piccolo

-----

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.

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

-----

Improved how ``create_pydantic_model`` handles ``Array`` columns:

* Multidimensional arrays (e.g. ``Array(Array(Integer))``) have more accurate
types.
* ``Array(Email())`` now validates that each item in the list is an email
address.
* ``Array(Varchar(length=10))`` now validates that each item is the correct
length (i.e. 10 in this example).

Other changes
~~~~~~~~~~~~~

Some Pylance errors were fixed in the codebase.

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

-----

Fixed a bug with array inputs in custom forms (thanks to sinisaos for this).

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

-----

Fixed a bug with nested array columns containing ``BigInt``. For example:

.. code-block:: python

class MyTable(Table):
my_column = Array(Array(BigInt))

Thanks to AmazingAkai for reporting this issue.

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

-----

Fixed a bug with foreign keys which reference ``BigSerial`` primary keys.
Thanks to Abdelhadi92 for reporting this issue.

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