Looks like one of the benefits is the ability to query nested data sets. When i need that i usually do that by generating a single json response in the query us

Looks like one of the benefits is the ability to query nested data sets. When i need that i usually do that by generating a single json response in the query using row_to_json, but that's not really standard sql, and requires an additional deserialization step. I wonder what sql statement they generate to support nested sets.