I have a client sending me .json files to feed into SQL for processing. I ended up hacking up a powershell script to read the json file to a powershell object, then I could iterate through the powershell object to pull out the pieces that I needed and stuff them into some staging tables.

Look up cmdlet ConvertFrom-Json