We all know that JSON data can be stored in SQL database as text, however, it was not possible directly to query and parse this JSON text right into database engine. Historically, we all have been using some sort of parsing outside of database; such JSON.Net library using C#.NET.

However, SQL Server 2016 has now introduced native support to parse JSON text. Please read the following Visual Studio Magazine article for further details. I have been looking for this type of support and found this article useful. Therefore, I am sharing this detail and hoping that it may be helpful to someone else.

https://visualstudiomagazine.com/articles/2018/01/17/query-json.aspx

Happy coding!