[showkhill]

The Generating JSON from SQL episode is cool but i'd really like to see an advanced follow up. For instance I've written a query to serialise a collection of records that have many relationships embedded, that conforms to the jsonapi 1.0 standard. Works great but very messy with deeply nested subqueries - hard to read, hard to reuse or alter. I'd really like to see an episode demonstrating a more composable way to craft a complex query like the aforementioned.