I'm doing this even more extreme... querying a whole complex object graph based on an entity framework core model :)
<a href="https://github.com/MUnique/OpenMU/blob/master/src/Persistence/EntityFramework/Json/JsonQueryBuilder.cs" rel="nofollow">https://github.com/MUnique/OpenMU/blob/master/src/Persistenc...</a>
Oracle has cursor expressions that returns a resultset inside a cell from the parent resultset. The whole resultset could then be serialized to json, xml or whatever<p>I wish there was an equivalent function in PostgreSQL. I've even asked a question about that on stackoverflow:<p><a href="https://stackoverflow.com/questions/8637050/cursor-inside-sql-query" rel="nofollow">https://stackoverflow.com/questions/8637050/cursor-inside-sq...</a>