This procedure processes a JSON object and returns the processed data as a SQL data type. The type of return variable is determined
when the procedure is executed. In most cases, the return variables are either ROW or ARRAY SQL data types.

The sp_parse_json system procedure returns a VARCHAR fragment for its base ARRAY or OBJECT when subsequent instances return
a different number of nodes.

JSON object identifiers must comply with the identifier rules defined in the database server. As well, the database server
enforces the same limits for JSON data types as it does for the underlying ROW and ARRAY data types.

The following example sets up a table with some data to generate a JSON string ([{"name":"Frank","age":51},{"name":"Bill","age":22},{"name":"Jackie","age":37}]) that can be parsed. It then parses the JSON string into a SQL array data type.