If your data is a JSON string, the PARSE function can be used to convert it into an object which can then be further manipulated and processed.
select PARSE(<JSON String Column>)
Example:
In this example, Name field's value is an array of map of Last Name and First Name.:
<jsp:include page="../inc/c9QueryTesterInc.jsp"> <jsp:param name="c9SQL" value=" select parse(Profile) as Profile, parse(Versions) as Versions, parse(description) as Description; select Profile.name, Description " /> <jsp:param name="pasteData" value=" [ {"Profile":"{\"name\":\"knowi\",\"age\":20}", "Versions":"[{\"ver\":12},{\"ver\":13}]","Description":"Employee account"} ] " /> </jsp:include>