JSON Decode SQL Server CLR Function
SQL Server has a lot of features, functions, and power.
One of the little used but highly useful features is called SQL Server CLR.
This allows one to write a C# DLL program that can be called by a SQL Server function to do custom data transformations.
This is one I wrote that decodes JSON automatically.