Feature: support multiple expressions in unwind

[min-mwei]

API

Other

Description

Below is an example, The intent is to flatten (and reconstruct) nested data types.

kuzu> with '{"a": {"id": 1}, "b": {"id": 2}}' as data with json_keys(data) as keys, json_extract(data, json_keys(data)) as vals unwind vals as val return val;
┌──────────┐
│ val      │
│ STRING   │
├──────────┤
│ {"id":1} │
│ {"id":2} │
└──────────┘
(2 tuples)
(1 column)
Time: 0.47ms (compiling), 10.21ms (executing)
kuzu> with '{"a": {"id": 1}, "b": {"id": 2}}' as data with json_keys(data) as keys, json_extract(data, json_keys(data)) as vals unwind keys as key, vals as val return val;
Error: Parser exception: Query must conclude with RETURN clause (line: 1, offset: 122)
"with '{"a": {"id": 1}, "b": {"id": 2}}' as data with json_keys(data) as keys, json_extract(data, json_keys(data)) as vals unwind keys as key, vals as val return val"
                                                                                                                           ^^^^^^