JSON → SQL INSERT
Convert a JSON array to SQL INSERT statements
Table:
Dialect:
mysql
postgresql
sqlite
tsql
JSON
159 chars
SQL
Copy SQL
[ { "id": 1, "name": "Alice", "email": "alice@example.com", "active": true }, { "id": 2, "name": "Bob", "email": "bob@example.com", "active": false } ]
INSERT INTO "users" ("id", "name", "email", "active") VALUES (1, 'Alice', 'alice@example.com', 1); INSERT INTO "users" ("id", "name", "email", "active") VALUES (2, 'Bob', 'bob@example.com', 0);