Bulk query generator

Paste a CREATE TABLE or a list of fields — get one query per column.

Check

Write SQL for

Row-level differences for one column, using a per-type sentinel inside coalesce. Uses a typed variable so each data type gets an appropriate sentinel. Note the known gap: if one side is NULL and the other holds the sentinel value itself, the rows compare equal and the difference is missed. The null-safe preset below has no such gap.

Fill in your tables

These stay the same for every generated query.

This template has nothing to fill in.

Anything in {{double braces}} gets replaced. To turn part of the query into a variable, select it and click below.

or type a column:

Paste your columns

One column per line. The boxes line up row by row.

Column names

One per line.

5 columns

Output column names

This check compares the same name in both tables.

Same names as the left

Data types

This check does not use data types.

5 types

Your queries

Paste a list of fields above.

Nothing generated yet.