Also, the "JSON Support in SQL Server 2016" Redgate Community article provides a ... If you have an array of a nested object that you want to extract, then you must resort to the JSON_QUERY function.

while SQL server 2016 CTP3 is expected to incorporate the ability to load JSON text in tables, extract values from JSON text, index properties in JSON text stored in columns, and more, he said. The ...

A public preview of SQL Server 2025 adds new vector capabilities already found in rival databases, along with JSON support ...