IoT Core Rule SQL To TimeStream

I have a payload of:

{"telemetry": [{"feed": "Channel 1", "reading": 52.7,"unit": "PSI"},{"feed": "Channel 2", "reading": 36.29,"unit": "PSI"},{"feed": "Channel 3", "reading": 34.7,"unit": "PSI"}]}

I have tried a couple of rules:

1st rule >SELECT get(telemetry,0).feed as feed, get(telemetry,0).reading as reading, get(telemetry,0).unit as unit FROM 'my_topic/#' but with this rule it only gives me the 1st in the array, how would i iterate through the whole array? The length of the array can vary so i cannot hard code it.

2nd rule >SELECT (SELECT VALUE feed FROM telemetry) as feed, (SELECT VALUE reading FROM telemetry) as reading, (SELECT VALUE unit FROM telemetry) as unit FROM 'my_topic/#'

Rule has action to TimeStream with dimensions:

TenantId = TenantId (Hard coded tenant id)

Feed = ${feed} and have also tried ${telemetry.feed}

1st problem: I get Errors at dimensions.1: [Dimension value can not be empty.]

2nd problem: If i keep only 1 dimension which is TenantId, it will insert but i really want "Feed" as a dimension. Moreover, I do not like the value of ["Channel 1","Channel 2","Channel 3"] as a value stored in TimeStream as well as the reading is not inserted when I use the 2nd rule. I very much prefer the 1st rule where each reading has a record.

Any help is much appreciated.