JSON to SQL
DeveloperGenerate SQL INSERT from JSON data
Options
Column types are inferred from every row. Nested objects/arrays become JSON columns.
JSON
SQL · 3 rows × 8 columns
CREATE TABLE IF NOT EXISTS "users" (
"id" INTEGER PRIMARY KEY,
"name" TEXT NOT NULL,
"email" TEXT,
"active" BOOLEAN NOT NULL,
"score" DOUBLE PRECISION NOT NULL,
"joined" TIMESTAMPTZ,
"tags" JSONB,
"manager_id" INTEGER
);
INSERT INTO "users" ("id", "name", "email", "active", "score", "joined", "tags", "manager_id") VALUES
(1, 'Ada Lovelace', 'ada@example.com', TRUE, 98.5, '2024-03-01', '["admin"]', NULL),
(2, 'Alan O''Neil', NULL, FALSE, 72, '2024-06-15T09:30:00Z', NULL, NULL),
(3, 'Grace Hopper', 'grace@example.com', TRUE, 88, NULL, NULL, 1);