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


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 ...)
Valid if not creating VIEW for SELECT

Step 3: Generate output