What does SQL Query Builder actually do?

The SQL builder assembles a statement from the tables, columns, and filters you add in the form. It does not know your schema and it does not execute the query. The SQL is a draft. Identifiers are inserted as you type them, so quoting and injection safety are still your job when you later add user input.

When should I use SQL Query Builder?

Use it to sketch a SELECT you will paste into a client.

When should I not use SQL Query Builder?

Do not concatenate raw user input into the statement it prints.

What does SQL Query Builder not do?

No database connection. Does not parameterize untrusted input for you.

SQL Query Builder

Visually build SELECT queries with WHERE / ORDER BY / LIMIT clauses. Free online — runs locally, no upload.

Columns (comma-separated)

Table

DISTINCT

WHERE Clauses

WHERE

ORDER BY

LIMIT (0 = no limit)

Generated SQL

SELECT id, name, email
FROM users
WHERE active = 'true'
ORDER BY created_at DESC
LIMIT 100;

Search tools

SQL Query Builder