Convert JSON to SQL


Use this tool to convert JSON into SQL. This tool works well with record like JSON objects in an array. It will flatten nested objects.
See also Convert SQL to JSON

Step 1: Select your input

Option 1 - Choose JSON file Encoding
Option 2 - Enter an URL
Option 3 - paste into Text Box below

  Examples:

Step 2: Choose output options


Output Options If JSON variable A, name the array to convert:


NOTE - you can change the column names below by overwriting the Field Name value.
   


 
 



For INSERT (REPLACE INTO tablename ....)

(INSERT phrase INTO ...)
For SELECT and MERGE
Valid if not creating VIEW for SELECT

Step 3: Generate output




.sql