This message was deleted.

It is still experimental in Druid 26.0, but have a look at UNNEST....unfortunately I don't think you can use it with complex<JSON> content in the array yet. I'm told there is work being done on this front. Let me start with, this is not pretty but for now: a different way would be to ingest

keys

as complex<json> and then spell out the iteration through the array manually with something like this where you'd likely need to go up to a high array index value to cover the largest arrays in your data:

SELECT *
FROM "inline_data"
WHERE
  (
     (JSON_VALUE(keys, '$[0].name') = '$flow.key.i_CustomerName'  AND JSON_VALUE(keys, '$[0].value') = 'TEST')
     OR
     (JSON_VALUE(keys, '$[1].name') = '$flow.key.i_CustomerName' AND JSON_VALUE(keys, '$[1].value') = 'TEST' )
   )