unnest
Expand nested structures
To unnest is to flatten or extract something from within a nested structure.
In computing and data work, unnesting transforms hierarchical or embedded data into a simpler form: The query unnests the array into individual rows.
The term appears in programming, database operations, and spreadsheet functions where nested elements need to be pulled out to a single level.
Undo knots or confusion
- disentangleFree from snarls
- unravelSeparate intertwined strands
- straightenMake linear or orderly
- clarifyMake something understandable
streamline · unwrap · unpack · linearize · reduce · distill · decompose · break down
untangle
Undo knots or confusion
- disentangleFree from snarls
- unravelSeparate intertwined strands
- straightenMake linear or orderly
clarify · streamline · unwrap · unpack · linearize · reduce · distill · decompose · break down · separate
flatten
Make level or smooth
- expandIncrease in size
- denormalizeIntroduce redundancy deliberately
- explodeBurst with sudden force
unwrap · unpack · spread · decompose · extract · separate · isolate · parse · transform · convert
SQL
Database manipulation language
- arrayOrdered collection or display
- JSONLightweight data interchange format
- queryRequest for information
column · row · table · subquery · CTE · record · tuple · element · collection · aggregate