Nested select feature + video

[dantownsend]

We recently added a cool new feature, which I'm calling 'nested select' because I can't think of a better way to describe it ...

>>> Band.select(Band.all_columns(), Band.manager.all_columns()).output(nested=True).run_sync()
{'id': 1, 'name': 'Pythonistas', 'manager': {'id': 1, 'name': 'Guido'}}

It also has great Pydantic support.

Here's video about it:

https://www.youtube.com/watch?v=NRO0HyFCCCI

[aminalaee]

@dantownsend Do you want to drop a link to these video playlists in README/doc?

[sinisaos]

@aminalaee This is great idea. @dantownsend You can also update the tutorials on the main Piccolo ORM website

[dantownsend]

Yes, good points - we should link to these videos in the docs and website. Will update the website now.

[wmshort]

Brilliant. The new nested model support is fantastic; exactly what was needed. Can it be extend also to objects()?

[dantownsend]

It's possible - I'll have a think about how best to do it.

[dantownsend]

I've added a prototype for nested objects - any thoughts on the API are welcome:

#217