Azure Data Studio can display nicely formatted JSON data
Update: Microsoft is retiring Azure Data Studio but this feature is also available in the MSSQL extension for VS Code If you click on a cell with json data in the results grid in Azure Data Studio, then it will automatically open a new tab with the json nicely formatted and syntax highlighted. Very handy for quickly checking the data stored in some rows with just a quick select *.