Json convert to a sql?

I see a few posts but nothing directly on target -
I'm trying to take the output of the Maker API for all my real devices and create a SQL table with relationships (or not) so I can create a searchable DB for 'show me all presence devices' or 'show me all switches etc etc.

Is there an ultrasimple route someones already created or do I have to do this from scratch?
I have successfully run SQLizer on the json but it's not easily importing into a SQL server db...