Question 1

What kinds of SQL can this converter handle?

Accepted Answer

It parses INSERT statements (INSERT INTO table (cols) VALUES (...)) and produces a JSON array of objects keyed by column name. It also handles bare column-list + value-tuples, single-row results, and multiple INSERT statements at once. NULL, numbers, booleans, single-quoted strings and double-quoted identifiers are all recognised.

Question 2

How are SQL values typed in the JSON output?

Accepted Answer

SQL NULL becomes JSON null. Unquoted numeric tokens become JSON numbers (Int or Float). The tokens true, false (and 1/0 with the boolean option) become JSON booleans. Everything else, including single-quoted strings, becomes a JSON string. Quoted string escapes ('' and \' ) are unescaped automatically.

Question 3

Does it run INSERT INTO ... VALUES with multiple rows?

Accepted Answer

Yes. A single INSERT with multiple value tuples like VALUES (1,'a'),(2,'b') produces a JSON array with one object per row. When several INSERT statements are pasted, each is merged into the same output array.

Question 4

Is my SQL sent to a server?

Accepted Answer

No. All parsing and conversion happens entirely in your browser using JavaScript. Nothing is uploaded, stored, or transmitted. The tool works offline after the page loads.