Sql Server 2016 and DocumentDb enable you to query JSON documents. DocumentDb has nice syntax for querying JSON documents – you can find some good examples on DocumentDb site . Sql Server provides built-in functions for accessing JSON fields (JSON_VALUE), fragments (JSON_QUERY) and opening JSON documents (OPENJSON). In this post, I will show you some queries that can be executed in DocumentDb and equivalent Sql Server queries.

...(read more)

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2015/10/06/querying-json-documents-in-sql-server-2016-and-documentdb.aspx