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.

SQL Server 2025 is also introducing a native JSON datatype, which should improve performance over the current approach of storing JSON data in the VARCHAR (MAX) field.