SQL CASE WHEN Generator

Paste your CREATE TABLE statements and get ready-to-run CASE WHEN queries — equality maps, range buckets, conditional aggregates, and UPDATE patterns. Supports 5 SQL dialects.

Input SQL

Column types are analyzed to suggest the most useful CASE patterns.

Generated Queries

Paste SQL and click Generate to see CASE WHEN statements.

Need to diff two schemas and generate migrations?

SchemaLens compares SQL schemas, detects breaking changes, and generates safe forward + rollback migrations — all in your browser.

Try SchemaLens Free