Name: SQL to JSON Converter
Author: PureFormatter

Question 1

What SQL statements are supported?

Accepted Answer

PureFormatter supports INSERT INTO statements with column lists and multiple value rows, which is the most common format for SQL data exports. CREATE TABLE statements are also supported and produce a JSON Schema object describing the table structure with inferred JSON types for each column. SELECT result sets are not supported — for those, use your database client's CSV or JSON export feature.

Question 2

Are data types inferred from SQL values?

Accepted Answer

Yes. Numeric values are converted to JavaScript numbers, quoted strings have their quotes removed and become JSON strings, NULL becomes JSON null, and TRUE/FALSE become JSON booleans. This produces clean, typed JSON that matches the data model of the original SQL table without requiring schema information.

Question 3

Can I convert MySQL dump files?

Accepted Answer

MySQL dump files containing INSERT statements can be pasted and converted. For very large dump files, paste individual INSERT statements rather than the entire file. The converter handles multi-row INSERT syntax where multiple value groups are comma-separated within a single INSERT statement, which is the format used by mysqldump.

Question 4

What about SQL with comments?

Accepted Answer

SQL comments using both -- single-line and /* multi-line */ syntax are stripped before parsing, so commented-out code does not affect conversion. This means you can paste SQL that contains inline documentation or commented alternative queries without errors.

SQL to JSON Converter

What is a SQL to JSON Converter?

How to Use PureFormatter

Frequently Asked Questions