Source
How to parse special characters in PARSE_JSON function
Using two or three backslashes will generate a compilation error, and four backslashes will cause two to be stored in the JSON data.
TO_JSON
Converts a VARIANT value to a string containing the JSON representation of the value. Syntax TO_JSON( <expr> ) Copy Arguments exprAn expression of type VARIANT that holds valid JSON information. Returns Returns a value of type VARCHAR.
TRY_PARSE_JSON
Returns a value of type VARIANT that contains a JSON document. If the input is NULL or if an error occurs during parsing, the function returns NULL. This function doesn’t return a structured type.