Hi , I have a JSON stream with nested arrays like:

{
  "day": 20230126,
  "stations": [
    {
      "name": "station1",
      "avail_spots": 1
    },
    {
      "name": "station2",
      "avail_spots": 2
    }
  ]
}

I am investigating how we can select the list of station names by day:

SELECT A.day, B.name FROM TOPIC1  as A JOIN INNER_ARRAY as B

Wonder if something like above is supported? Thanks 🙂 !