Enhancement: Add recursive relations to PiccoloDTO

[beerbrewingman]

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

---

Note

While we are open for sponsoring on GitHub Sponsors and
OpenCollective, we also utilize Polar.sh to engage in pledge-based sponsorship.

Check out all issues funded or available for funding on our Polar.sh Litestar dashboard

• If you would like to see an issue prioritized, make a pledge towards it!
• We receive the pledge once the issue is completed & verified
• This, along with engagement in the community, helps us know which features are a priority to our users.