What is the JSON_QUERY path in SQL Server 2019?

edit

JSONQUERY path is a function in SQL Server 2019 that returns a JSON fragment of the expression provided according to the JSON path specified. The syntax for JSONQUERY is:

JSON_QUERY (expression, JSON_Path)

The JSONPath is a string that specifies the path to the desired JSON object or array. For example, the following query retrieves the value of the "name" property from a JSON document stored in a column called "jsondata":

SELECT JSON_QUERY(json_data, '$.name') AS Name
FROM MyTable;

In this example, the JSON path '$.name' points to the "name" property of the JSON document.