
INSERT INTO ... VALUES (...) statements. The JSON appears as you type.data.json.To go the other way, choose JSON → INSERT, paste a JSON array of objects, enter the table name and pick SQL Server, MySQL or PostgreSQL. You can also set how many rows go into one INSERT and add a CREATE TABLE with column types guessed from the data.
INSERT INTO [dbo].[Users] ([Id], [Name]) VALUES (1, N'O''Brien'), (2, NULL); becomes [{"Id": 1, "Name": "O'Brien"}, {"Id": 2, "Name": null}].
[x], `x`, "x" and schema names such as dbo.Users.'', prefixes N'...' and E'...', MySQL backslash escapes (turned on automatically when the script uses backticks).NULL, TRUE/FALSE, numbers, hex 0x..., comments, GO and scripts without semicolons (SSMS "Generate Scripts").GETDATE() are kept as text.What if the INSERT has no column list? The keys are named column1, column2... in order.
Why is a number shown as a string? Integers larger than 9,007,199,254,740,991 and decimals with more than 15 significant digits cannot be stored exactly in a JavaScript number, so they are kept as strings to avoid changing the value.
Is INSERT ... SELECT supported? No. It has no literal values to convert, so the tool reports an error at that position.
Why does SQL Server get at most 1000 rows per INSERT? SQL Server rejects a VALUES list with more than 1000 rows, so larger batches are split automatically.