Convert SQL INSERT to JSON!

Input INSERT statements to convert them into a JSON array!
input
result
 

Convert SQL INSERT to JSON!

Input INSERT statements to convert them into a JSON array!

Use Cases

- Inspect dump data - Turn the INSERT statements of a database dump into JSON to read the data or move it to other tools. - Include CREATE TABLE - Add the CREATE TABLE too, and column names and types are used: TINYINT(1) becomes true/false and JSON columns become objects.