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.

And that’s how we can manipulate XLS, JSON, and CSV files with csvkit. This tool might not be used very often, but when you need it, you’ll be happy it’s around.

While I could switch to using SQL Server's new ability to convert query results into JSON, the existing code has that whole "working" feature that people like so much -- I have no desire to replace it ...