Jack Vamvas shows how you can import data in JSON format and get tabular data in SQL Server:
It is possible to read a json file using T-SQL.There are a number of different methods. By using the OPENROWSET functionality , ISJSON and OPENJSON function you can quickly read the file , check if the JSON is valid and then unpack the JSON into a SQL table.
Read on for an example. This also performs reasonably well in practice, at least in my experience.