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.