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.

They are XML databases, a way to store, search, and retrieve all that mission-critical business data that is finding expression in XML format.