SQL’s had sub-queries since SQL:92 - but it’s still a challenge to return properly nested data through SQL queries.
XTDB has first-class support for nested values, as well as NEST_ONE and NEST_MANY, which fill this gap:
2 Likes