Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Dunstan expanded on that by implementing query_to_json, record_to_json, and array_to_json functions that can be used in SQL queries to generate structured JSON responses.