Ok, let's start with the first bullet point: A query to create all the tables(QCreateTables).This implies you have DDL for your table(s). Could you post that please? We then know what the XML data needs to look like to be able to be inserted into those tables.

You also keep mention ion JSON, however, we've only seen XML so far. Which is it? If it's JSON, SQL Server 2014 is going to be a problem (JSON functions were only introduced with SQL Server 2016). JSON and XML are completely different, the acronyms are not interchangeable, so please don't say one when you mean the other.