Summary

As mentioned by @Goldziher in #1533 there currently isn't support for recursive relationships in PiccoloDTO. This would be a nice feature to have.

Basic Example

from piccolo.columns import ForeignKey, Integer, Varchar
from litestar.dto import DTOConfig
from litestar.contrib.piccolo import PiccoloDTO

class Manager(Table):
    name = Varchar(length=100)

class Band(Table):
    name = Varchar(length=100)
    manager = ForeignKey(references=Manager)
    popularity = Integer()

class BandOutputDTO (PiccoloDTO[Band]):
    config = DTOConfig(include={"name", "manager.name", "popularity"})

Drawbacks and Impact

No response

Unresolved questions

No response