Nested structures

Views and sub-views are not really new or unique. Everybody struggles with nested structures. Master / detail, XML, group by, pivot tables ... all have some aspects related to nesting and grouping.

Here's one I had not seen before:
Data Shaping and Advanced Data Shaping.

I'm still not convinced that either SQL extensions or XPath-/XQuery-like solutions are the "right" way to deal with these concepts.