JSONParser (version 1.5) - Aster Analytics

SELECT * FROM JSONParser (
  ON  tablename 
  TextColumn ('text_columnname')
  Nodes ('parentnode/childnode' [,...])
  [ SearchPath ('nodename/...') ]
  [ Delimiter ('delimiter_string') ]
  [ MaxItemNum ('number') ]
  [ NodeIDOutputColumn ('columnname') ]
  [ ParentNodeOutputColumn ('columnname') ]
  [ Accumulate
    ({ 'accumulate_column' | 'accumulate_column_range' }[,...]')]
  [ ErrorHandler ('{true|yes|t|y|1|false|no|f|n|0}
    [ [;output_col_name  :]  input_col_name[,...]') ] ]
);