Hi GJ; 

You are in luck: First you can pulle out the JSON array as a table with "jsonAsTableRow". This gives you a JSON object for each array element, however you can simply pull out each value now an give it nice DB/2 namves with the jsonGetInt() / jsonGetStr() functions.

With IceBreak on you library list; try this from an SQL prompt:

with myMap as ( Select value from table (jsonAsTableRow  ( '[ 
  { id:1, cust:"john"},                                       

  { id:2, cust:"Åge"}                                         

]','')) myVirtualMap                                          

)                                                             

select                                                        

  jsonGetInt(value  , 'id'  ) as id,                          

  jsonGetStr(value  , 'cust') as cust                         

from myMap  

.. Your "myMap" table is good to use with joins and other sql features. You will now get:

Best regards,

Niels Liisberg