diff_results
Answer "do these two queries return the same thing?" — the self-check for query refactors. Executes query_a and query_b against identical fresh databases and compares result multisets (order-insensitive; order divergence reported separately when ORDER BY is present). Returns equal:boolean, row counts, and capped row-level diffs (only_in_a / only_in_b).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| seed | No | Optional seed rows: {"table_name": [{"col": value, ...}, ...]}. Max 10MB total. | |
| engine | No | Engine. Server-side supports 'sqlite' (default). 'duckdb' runs in the browser demo at sqlai.dev only. | |
| schema | Yes | DDL statements. | |
| query_a | Yes | Original query. | |
| query_b | Yes | Refactored/alternative query. |