`UNNEST`

[okennedy]

It would be nice to have an UNNEST operator, essentially an inverse aggregate (one row/cell to many).

Examples:

• Iterate over the elements of a JSON array
• Regexp matches in a given object
• Fields of a CSV

SQLite already supports something of this flavor (e.g.,. The JSON TVFs), but the way it's implemented is a violation of classical SQL (so it's going to need a special implementation within Mimir).

[okennedy]

Spark also has this functionality. It should be much easier now.