Back to Free Tools
FREE TOOLS
SQLite SELECT and UPDATE Builder
Build a parameterized SQLite SELECT or guarded UPDATE statement from strict JSON.
Pasted JSON request, One UTF-8 JSON request file
query.sql, query-bindings.json
Browser only
Runs locally in your browser. Your files, pasted content and generated output are not uploaded. Reset clears this tool’s working data.
This tool needs JavaScript. If it does not load, refresh the page and try again.
How to use this tool
- Enter a strict select or update request, or select one UTF-8 file.
- Keep query fields inside the JSON document. SELECT needs columns; UPDATE needs assignments and a nonempty WHERE list.
- Select Build SQLite statement, then download SQL and typed bindings.
Examples
A select request for items/id with limit 100 creates SELECT "id" FROM "items" LIMIT 100; with no value bindings.
Limitations
- At most 1 MiB source and combined output, 10 levels, 10,000 parsed values, 100 selected columns/assignments/conditions, 20 order columns, 200 UTF-16 units per identifier and 30 seconds.
- Identifiers are quoted whole names, including dots. Values use parameters; exact signed 64-bit integers, literal text/null and boolean 0/1 are distinct. Noninteger REAL conversion is binary64 approximate; overflow and underflow-to-zero refuse.
- Only AND and the listed comparisons/null predicates. No OR, JOIN, expressions, subqueries, database connection or execution. A nonempty UPDATE WHERE is structural, not a guarantee of safe intent.
Related tools
No items found.