[feature] expanded detail page

[fgregg]

Right now, if click on the detail page for a row you get the info for the row and links to related tables:

It would be very cool if there was an option to expand the rows of the related tables from within this detail view.

If you had that then datasette could fulfill a pretty common use case where you want to search for an entity and get a consolidate detail view about what you know about that entity.

[simonw]

That's a really interesting idea!

That page is one of the least developed at the moment. There's plenty of room for it to grow new useful features.

I like this suggestion because it feels like a good opportunity to introduce some unobtrusive JavaScript. Could use a details/summary element that uses fetch() to load in the extra data for example.

Could even do something with the <datasette-table> Web Component here... https://github.com/simonw/datasette-table