Since I asked a question, I just couldn't find a native to sql server solution that would work and will be easy to implement.

My data (json) is coming from ElasticSearch.

There is many articles on how to move data from sql server to ES, but non on how to go the other way.

I ended up querying ES, parsing JSON and populating sql server in Python.