I'm using the latest(0.117) Presto and trying to execute **CROSS JOIN UNNEST** with complex JSON array like this.

```
[{"id": 1, "value":"xxx"}, {"id":2, "value":"yy"}, ...]

```

To do that, first I tried to make an **ARRAY** with the values of **id** by 

```
SELECT CAST(JSON_EXTRACT('[{"id": 1, "value":"xxx"}, {"id":2, "value":"yy"}]', '$..id') AS ARRAY<BIGINT>)

```

but it doesn't work.

What is the best JSON Path to extract the values of **id**?