SQL Query Generator - From a Question to a Query

How the SQL Query Generator Works

1. 01Write the question the query should answer, as you would ask a colleague.
2. 02Pick the database: PostgreSQL, MySQL, SQLite, SQL Server or BigQuery. Date arithmetic, string functions, limits and quoting differ between them.
3. 03Paste the table layout: CREATE TABLE statements or table names with their columns and how they link. The fewer assumptions the tool has to make, the better the query.
4. 04Read the assumptions and warnings, then run the query on a copy or inside a transaction.

Getting a Query You Can Trust

The quality of a generated query depends on what it knows about your tables. With the schema, the assumptions list shrinks to nothing; without it, every guessed name is listed so you can check before running anything. Dialect matters more than people expect: a query written for PostgreSQL fails on SQL Server in the first line. The warnings are worth reading twice: NOT IN with a subquery that can return NULL matches nothing, a function on an indexed column defeats the index, a join on a non-unique column doubles the rows before the SUM. The generator never writes INSERT, UPDATE, DELETE or DDL unless the question asks for a change, and marks the query when it does.

When to Use This Tool

When you can describe the report but not the joins. When you switch databases and the syntax you know does not carry over. When you want a starting point for a complex query and would rather review than write from scratch. When you want the query explained back to you to check that it matches the question.

Frequently Asked Questions