This example selects specific values from the JSON name/value pair using JSON string syntax. If a row does not have a specific name requested, null is returned.
select QueryID, RowNum, ParamJSON."Data Record".x from QryLogParamJSON;
Result:
QueryID RowNum ParamJSON.Data Record.x ------------------ ------ ----------------------- 307190733539634351 1 ? 307190733539634351 2 10