That's great! Didn't know you could do that so thanks for sharing. Since the original post I rewrote it in Python with pyodbc, but this may be even better. Python has great JASON handling
Found a good article on the JSON processing at mssqltips might be an idea to test it with MySQL etc as that was going to be my next test with my pyodbc code.