AI Demos Research — the structured-intelligence platform. Every verdict on these pages opens to the execution behind it.
Graded 14 October 2026

Can BlazeSQL preserve earlier constraints when a user narrows a request?

BlazeSQL preserved the earlier 90-day window when the user narrowed the request to Texas. The follow-up query kept the original date filter and added only the Texas filter, and the Texas export matched the Texas subset of the first export.

1 of 1 test case passed

Every test case in this scenario has a result.

Pass rate100%1 of 1 gradable
Coverage1 of 1test case with a result
1PassDid everything it was expected to do.
0FailNo test case failed.
0Not gradableEvery result here could be graded.
0UntestedEvery test case in this scenario has a result.
The pass rate is a summary. The evidence is the test case below: what we sent, what we checked, what the tool returned, and the proof.

The test case

Each test case is judged on its own: Pass, Fail, Not gradable, or Untested. The scenario result above is based on this test case.

Narrow the same question to one regionPassEvidence
What we sent

Input 1: “Show me all orders from the last 90 days, as of September 2, 2026.”

Input 2: “Only the ones shipped to Texas”

What the tool returned

The tool returned 2 files, shown under Proofs.

Response 1 replies to Input 1.

Response 2 replies to Input 2.

Response to input 1 91 orders were returned for the 90-day window (June 4 – September 2, 2026). A few quick observations: • 📦 Most orders are delivered, with a subset still in processing or packed stages (the most recent ones) • ❌ Several cancellations are scattered throughout the period • 💰 All orders are in USD, spanning a wide range of totals Would you like to dig deeper — e.g., break down by status, category, or customer? Response to input 2 7 orders shipped to Texas in that period. Would you like to do anything further with these results?

Transcribed from Proof 1 · Screenshot

Transcribed from Proof 2 · Screenshot

Output file 1 (CSV)
CSV export: the 91-order result set with seven Texas rows
CSV91 rows · 11 columns
order_numbercustomer_namecustomer_emailplaced_atstatuscategorytotal_amountcurrencycitystatepayment_method
ORD-2026-0091Ingrid Sorenseningrid.sorensen@example.com2026-09-01 23:32:58.158541processingstorage_and_organization144USDTucsonAZgoogle_pay
ORD-2026-0090Wei Zhangwei.zhang@example.com2026-09-01 23:05:58.158541processingkitchen_and_dining207.99USDEvanstonILpaypal
ORD-2026-0089Priya Raghavanpriya.raghavan@example.com2026-09-01 22:43:58.158541processingbedding_and_rugs156.99USDReadingPAcard
ORD-2026-0088Ingrid Sorenseningrid.sorensen@example.com2026-09-01 22:08:58.158541processinghome_decor59.98USDPittsburghPAcard
ORD-2026-0087Jae-won Parkjae-won.park@example.com2026-09-01 17:24:58.158541processingbedding_and_rugs638.98USDSeattleWAapple_pay
ORD-2026-0086Nathan Boonenathan.boone@example.com2026-09-01 16:38:58.158541processingoutdoor_and_patio616.99USDNashvilleTNcard
ORD-2026-0085Wei Zhangwei.zhang@example.com2026-09-01 14:29:58.158541processingfurniture3244.89USDEvanstonILaffirm
ORD-2026-0084Priya Raghavanpriya.raghavan@example.com2026-09-01 13:08:58.158541processinglighting525.5USDReadingPAcard
ORD-2026-0083Marcus Whitfieldmarcus.whitfield@example.com2026-09-01 11:49:58.158541packedhome_decor650.51USDDenverCOpaypal
ORD-2026-0082Dev Raghavandev.raghavan@example.com2026-09-01 11:07:58.158541packedlighting683.91USDBoulderCOcard
ORD-2026-0080Priya Raghavanpriya.raghavan@example.com2026-09-01 10:58:58.158541packedstorage_and_organization99USDReadingPAcard
ORD-2026-0081Wei Zhangwei.zhang@example.com2026-09-01 10:58:58.158541packedhome_decor504.84USDEvanstonILcard
ORD-2026-0079Marcus Whitfieldmarcus.whitfield@example.com2026-08-31 11:25:58.158541packedstorage_and_organization166.99USDDenverCOcard
ORD-2026-0078Nathan Boonenathan.boone@example.com2026-08-31 11:15:58.158541packedbedding_and_rugs296.5USDBoulderCOcard
ORD-2026-0077Ingrid Sorenseningrid.sorensen@example.com2026-08-31 11:07:58.158541packedoutdoor_and_patio579.99USDPortlandORcard
ORD-2026-0076Ana Lucia Ferreiraana.luciaferreira@example.com2026-08-30 11:48:58.158541shippedhome_decor468.9USDProvidenceRIcard
ORD-2026-0075Cassandra Popecassandra.pope@example.com2026-08-30 11:27:58.158541shippedkitchen_and_dining1448.06USDCharlotteNCgoogle_pay
ORD-2026-0074Yewande Adeyemiyewande.adeyemi@example.com2026-08-30 11:05:58.158541shippedbedding_and_rugs156.99USDAtlantaGAcard
ORD-2026-0073Rosa Delgadorosa.delgado@example.com2026-08-29 11:36:58.158541shippedhome_decor52.99USDDuluthMNapple_pay
ORD-2026-0072Deshawn Carterdeshawn.carter@example.com2026-08-29 11:09:58.158541shippedstorage_and_organization702.49USDSavannahGAcard
ORD-2026-0071Deshawn Carterdeshawn.carter@example.com2026-08-28 11:45:58.158541shippedlighting1703.09USDColumbusOHcard
ORD-2026-0070Yewande Adeyemiyewande.adeyemi@example.com2026-08-28 11:12:58.158541shippedlighting779.85USDAtlantaGAaffirm
ORD-2026-0069Deshawn Carterdeshawn.carter@example.com2026-08-28 11:05:58.158541shippedstorage_and_organization432USDSavannahGAcard
ORD-2026-0068Ingrid Sorenseningrid.sorensen@example.com2026-08-28 11:00:58.158541shippedhome_decor158.97USDPortlandORcard
ORD-2026-0067Alice Prosseralice.prosser@example.com2026-08-27 11:56:48.178874shippedbedding_and_rugs164USDDenverCOcard
ORD-2026-0065Priya Raghavanpriya.raghavan@example.com2026-08-26 11:31:58.158541shippedbedding_and_rugs141.29USDReadingPAapple_pay
ORD-2026-0066Wei Zhangwei.zhang@example.com2026-08-26 11:31:58.158541shippedhome_decor436.97USDSan AntonioTXcard
ORD-2026-0064Deshawn Carterdeshawn.carter@example.com2026-08-26 11:23:58.158541shippedstorage_and_organization166.99USDSavannahGApaypal
ORD-2026-0063Marcus Whitfieldmarcus.whitfield@example.com2026-08-25 11:48:58.158541shippedoutdoor_and_patio1108.45USDDenverCOpaypal
ORD-2026-0062Hannah Kowalskihannah.kowalski@example.com2026-08-25 11:07:58.158541shippedhome_decor488.69USDSan AntonioTXcard
ORD-2026-0061Bruno Halvorsenbruno.halvorsen@example.com2026-08-24 11:56:48.178874shippedlighting245USDRenoNVcard
ORD-2026-0060Rosa Delgadorosa.delgado@example.com2026-08-23 13:54:58.158541cancelledstorage_and_organization44.55USDPhoenixAZcard
ORD-2026-0059Omar Haddadomar.haddad@example.com2026-08-20 06:47:58.158541deliveredstorage_and_organization623.44USDDearbornMIcard
ORD-2026-0058Ana Lucia Ferreiraana.luciaferreira@example.com2026-08-20 06:11:58.158541deliveredstorage_and_organization307.71USDAustinTXgift_card
ORD-2026-0057Priya Raghavanpriya.raghavan@example.com2026-08-20 05:51:58.158541deliveredlighting311.98USDEugeneORpaypal
ORD-2026-0056Priya Raghavanpriya.raghavan@example.com2026-08-20 00:49:58.158541deliveredkitchen_and_dining207.99USDReadingPAcard
ORD-2026-0055Yewande Adeyemiyewande.adeyemi@example.com2026-08-17 05:06:58.158541cancelledlighting126.5USDAtlantaGApaypal
ORD-2026-0054Tomas Lindqvisttomas.lindqvist@example.com2026-08-16 19:42:58.158541deliveredfurniture431.85USDMinneapolisMNcard
ORD-2026-0053Omar Haddadomar.haddad@example.com2026-08-12 04:57:58.158541deliveredlighting283.49USDDearbornMIcard
ORD-2026-0052Ingrid Sorenseningrid.sorensen@example.com2026-08-11 19:03:58.158541deliveredstorage_and_organization772.39USDPortlandORcard
ORD-2026-0051Jae-won Parkjae-won.park@example.com2026-08-11 14:51:58.158541deliveredhome_decor219.94USDClevelandOHcard
ORD-2026-0050Deshawn Carterdeshawn.carter@example.com2026-08-10 05:05:58.158541deliveredoutdoor_and_patio1757.7USDColumbusOHcard
ORD-2026-0049Cassandra Popecassandra.pope@example.com2026-08-09 17:00:58.158541deliveredbedding_and_rugs444.45USDCharlotteNCcard
ORD-2026-0048Alice Prosseralice.prosser@example.com2026-08-09 11:56:48.178874deliveredfurniture812.5USDDenverCOcard
ORD-2026-0047Jae-won Parkjae-won.park@example.com2026-08-06 16:08:58.158541cancelledoutdoor_and_patio1159.98USDSeattleWAcard
ORD-2026-0046Ingrid Sorenseningrid.sorensen@example.com2026-08-05 09:36:58.158541cancelledfurniture231.9USDPittsburghPAaffirm
ORD-2026-0045Wei Zhangwei.zhang@example.com2026-08-04 06:55:58.158541cancelledlighting155.99USDSan JoseCApaypal
ORD-2026-0044Tomas Lindqvisttomas.lindqvist@example.com2026-08-03 00:24:58.158541deliveredstorage_and_organization603.43USDAnn ArborMIcard
ORD-2026-0043Cassandra Popecassandra.pope@example.com2026-08-02 17:58:58.158541cancelledoutdoor_and_patio1233.98USDCharlotteNCgoogle_pay
ORD-2026-0042Ana Lucia Ferreiraana.luciaferreira@example.com2026-08-02 17:07:58.158541deliveredhome_decor1269.94USDSan AntonioTXcard
ORD-2026-0041Jae-won Parkjae-won.park@example.com2026-07-30 11:26:58.158541deliveredoutdoor_and_patio651USDAshevilleNCcard
ORD-2026-0040Tomas Lindqvisttomas.lindqvist@example.com2026-07-29 16:53:58.158541deliveredkitchen_and_dining207.99USDMinneapolisMNaffirm
ORD-2026-0039Yewande Adeyemiyewande.adeyemi@example.com2026-07-29 01:27:58.158541cancelledoutdoor_and_patio1850.97USDAtlantaGAgoogle_pay
ORD-2026-0038Alice Prosseralice.prosser@example.com2026-07-27 11:56:48.178874deliveredbedding_and_rugs128USDDenverCOapple_pay
ORD-2026-0037Ana Lucia Ferreiraana.luciaferreira@example.com2026-07-27 11:51:58.158541deliveredlighting253USDProvidenceRIpaypal
ORD-2026-0036Cassandra Popecassandra.pope@example.com2026-07-26 06:52:58.158541cancelledstorage_and_organization300.58USDCharlotteNCcard
ORD-2026-0035Rosa Delgadorosa.delgado@example.com2026-07-25 13:46:58.158541deliveredoutdoor_and_patio824USDPhoenixAZapple_pay
ORD-2026-0034Ingrid Sorenseningrid.sorensen@example.com2026-07-20 21:24:58.158541deliveredbedding_and_rugs1853.53USDPortlandORcard
ORD-2026-0033Marcus Whitfieldmarcus.whitfield@example.com2026-07-19 16:46:58.158541deliveredstorage_and_organization792.05USDDenverCOgoogle_pay
ORD-2026-0032Wei Zhangwei.zhang@example.com2026-07-16 04:18:58.158541deliveredlighting253USDSan JoseCAcard
ORD-2026-0031Dev Raghavandev.raghavan@example.com2026-07-13 23:13:58.158541deliveredfurniture693USDReadingPAcard
ORD-2026-0030Ana Lucia Ferreiraana.luciaferreira@example.com2026-07-12 22:14:58.158541deliveredhome_decor127.45USDAustinTXcard
ORD-2026-0029Omar Haddadomar.haddad@example.com2026-07-12 09:03:58.158541deliveredhome_decor58.05USDDearbornMIcard
ORD-2026-0028Omar Haddadomar.haddad@example.com2026-07-11 23:01:58.158541cancelledfurniture115.95USDDearbornMIapple_pay
ORD-2026-0027Omar Haddadomar.haddad@example.com2026-07-11 04:03:58.158541deliveredbedding_and_rugs268USDDearbornMIcard
ORD-2026-0026Wei Zhangwei.zhang@example.com2026-07-11 00:32:58.158541deliveredoutdoor_and_patio616.99USDSan JoseCApaypal
ORD-2026-0025Dev Raghavandev.raghavan@example.com2026-07-10 11:30:58.158541deliveredbedding_and_rugs2223.99USDReadingPAgoogle_pay
ORD-2026-0024Dev Raghavandev.raghavan@example.com2026-07-05 21:07:58.158541deliveredoutdoor_and_patio616.99USDReadingPApaypal
ORD-2026-0023Hannah Kowalskihannah.kowalski@example.com2026-07-04 14:50:58.158541deliveredfurniture3108.45USDSan AntonioTXaffirm
ORD-2026-0022Wei Zhangwei.zhang@example.com2026-07-04 12:24:58.158541deliveredstorage_and_organization1583.35USDSan JoseCAaffirm
ORD-2026-0021Priya Raghavanpriya.raghavan@example.com2026-07-04 10:22:58.158541deliveredkitchen_and_dining198.99USDTucsonAZcard
ORD-2026-0020Ingrid Sorenseningrid.sorensen@example.com2026-06-29 19:01:58.158541deliveredbedding_and_rugs187.94USDTucsonAZcard
ORD-2026-0019Omar Haddadomar.haddad@example.com2026-06-29 16:56:58.158541deliveredhome_decor105.98USDDearbornMIpaypal
ORD-2026-0018Dev Raghavandev.raghavan@example.com2026-06-29 11:29:58.158541deliveredbedding_and_rugs134.97USDReadingPAgoogle_pay
ORD-2026-0017Wei Zhangwei.zhang@example.com2026-06-28 16:04:58.158541deliveredkitchen_and_dining211USDSan JoseCAcard
ORD-2026-0016Omar Haddadomar.haddad@example.com2026-06-28 00:49:58.158541deliveredkitchen_and_dining415.98USDDearbornMIpaypal
ORD-2026-0015Rosa Delgadorosa.delgado@example.com2026-06-27 03:36:58.158541deliveredoutdoor_and_patio580.5USDPhoenixAZapple_pay
ORD-2026-0014Rosa Delgadorosa.delgado@example.com2026-06-24 08:29:58.158541deliveredfurniture536.99USDDuluthMNcard
ORD-2026-0013Alice Prosseralice.prosser@example.com2026-06-23 11:56:48.178874deliveredhome_decor76USDDenverCOcard
ORD-2026-0012Hannah Kowalskihannah.kowalski@example.com2026-06-19 20:14:58.158541deliveredhome_decor204.49USDSan AntonioTXaffirm
ORD-2026-0011Hannah Kowalskihannah.kowalski@example.com2026-06-18 00:23:58.158541deliveredstorage_and_organization306.99USDChicagoILcard
ORD-2026-0010Deshawn Carterdeshawn.carter@example.com2026-06-17 02:45:58.158541deliveredbedding_and_rugs249.29USDColumbusOHcard
ORD-2026-0009Wei Zhangwei.zhang@example.com2026-06-16 20:47:58.158541deliveredoutdoor_and_patio651USDEvanstonILpaypal
ORD-2026-0008Marcus Whitfieldmarcus.whitfield@example.com2026-06-13 04:05:58.158541deliveredoutdoor_and_patio1244.58USDDenverCOcard
ORD-2026-0007Ingrid Sorenseningrid.sorensen@example.com2026-06-13 03:56:58.158541cancelledfurniture676.35USDSacramentoCAgift_card
ORD-2026-0006Jae-won Parkjae-won.park@example.com2026-06-12 18:40:58.158541cancelledkitchen_and_dining351.97USDSeattleWAcard
ORD-2026-0005Deshawn Carterdeshawn.carter@example.com2026-06-12 17:56:58.158541cancelledlighting126.5USDSavannahGAcard
ORD-2026-0004Rosa Delgadorosa.delgado@example.com2026-06-12 17:00:58.158541deliveredbedding_and_rugs370.63USDDuluthMNapple_pay
ORD-2026-0003Rosa Delgadorosa.delgado@example.com2026-06-11 14:27:58.158541deliveredstorage_and_organization739.88USDPhoenixAZpaypal
ORD-2026-0002Hannah Kowalskihannah.kowalski@example.com2026-06-11 05:14:58.158541deliveredlighting1587.9USDChicagoILcard
ORD-2026-0001Priya Raghavanpriya.raghavan@example.com2026-06-10 18:14:58.158541deliveredbedding_and_rugs1430.08USDReadingPApaypal
Open the CSV file ↗
Output file 2 (CSV)
CSV export: the seven Texas rows from the narrowed result set
CSV7 rows · 11 columns
order_numbercustomer_namecustomer_emailplaced_atstatuscategorytotal_amountcurrencycitystatepayment_method
ORD-2026-0066Wei Zhangwei.zhang@example.com2026-08-26 11:31:58.158541shippedhome_decor436.97USDSan AntonioTXcard
ORD-2026-0062Hannah Kowalskihannah.kowalski@example.com2026-08-25 11:07:58.158541shippedhome_decor488.69USDSan AntonioTXcard
ORD-2026-0058Ana Lucia Ferreiraana.luciaferreira@example.com2026-08-20 06:11:58.158541deliveredstorage_and_organization307.71USDAustinTXgift_card
ORD-2026-0042Ana Lucia Ferreiraana.luciaferreira@example.com2026-08-02 17:07:58.158541deliveredhome_decor1269.94USDSan AntonioTXcard
ORD-2026-0030Ana Lucia Ferreiraana.luciaferreira@example.com2026-07-12 22:14:58.158541deliveredhome_decor127.45USDAustinTXcard
ORD-2026-0023Hannah Kowalskihannah.kowalski@example.com2026-07-04 14:50:58.158541deliveredfurniture3108.45USDSan AntonioTXaffirm
ORD-2026-0012Hannah Kowalskihannah.kowalski@example.com2026-06-19 20:14:58.158541deliveredhome_decor204.49USDSan AntonioTXaffirm
Open the CSV file ↗
Expected vs. Found
✓Expected: Returns the subset of t1's answer, with t1's other conditions still applied.Found: It returned only the Texas rows while keeping the original date window.
Supporting proof
Proof 1Screenshot
Chat screenshot: the first request, the generated query, and 91 returned orders
Open original ↗
Proof 2Screenshot
Chat screenshot: the follow-up request, narrowed query, and seven Texas orders
Open original ↗
Why this result

It is a pass because the follow-up kept the first answer's date window and added only Texas, so the Texas rows are a subset of the first result.

Also observed in this test case

Columns kept. Both exports kept all 11 columns.

Tested by Ayush Ghosh · evidence dated 21 September 2026
Limitations of this result

The narrowing was checked against the 91 rows the product returned, not the full 100-row window.

Configuration and setup

How this tool was set up for the run and what the test needed in place. Each row is a fact from the run's records; a fact the records do not hold is left out, not guessed.

Software that produced the output
BlazeSQL
Build or version
1.8.93
Surface
Web app
Set up before the run
The first answer had to contain both Texas and non-Texas rows so a later request could narrow the same result set.
Tested
21 September 2026 · Ayush Ghosh

How this scenario is graded

How we decide Pass, Fail and Not gradable. The same rules apply to every tool tested on this scenario.

How results are decided

Each test case gets one result per tool: Pass, Fail or Not gradable. A test case we haven't run yet shows Untested. There are no partial results.

The rules
  • Pass: the tool did everything the test expected, and nothing it said contradicts the correct answer.
  • Fail: at least one expected behaviour clearly didn't happen; the test case's result says which one and quotes the tool.
  • Not gradable: our evidence couldn't settle the outcome (for example a record we needed is missing). It is never counted as a fail, and the test case's result says what's missing.

Where this sits in the benchmark

This page is one cell of a larger study: one tool, one scenario. Only this benchmark's frame appears here.

History of this result

What has happened to this result since it was first published. Runs and grades are never overwritten: a retest or a re-grade publishes a new result and keeps the earlier one readable.

from the publication record
14 October 2026First publishedAI Database Agents v1

Act on this result

Nothing filed here edits the run or the grade. A challenge opens a review, and a review can produce a new run or a re-grade — which becomes the current result and leaves this one in the history.

This matches what I see

You run the same kind of test against your own setup and get the same behaviour.

Agree →
This does not match

Yours behaves differently. Tell us what you got, with a screenshot if you have one.

Disagree →
Point out an issue

Something here is wrong — a reference value, a transcription, a grade.

Report an issue →
Request a retest

On a newer build, a larger dataset, or your own setup.

Request a retest →
We have fixed this

Tell us what changed and we schedule a rerun of the failing test case. The old result stays as history.

Vendor notice →
Filed against this evidenceNothing yet. Challenges, counter-evidence and fix notices appear here with their outcome, and stay on the page after they are resolved.
Cite this result
aidemos.com/benchmarks/ai-database-agents/results/blazesql/the-user-narrows-what-they-just-asked · 1 pass · 0 fail · coverage 1/1 · graded 2026-10-14

The same record is available as structured data through the AI Demos MCP server, with the counts, the coverage and every per-test-case reason carried as fields.

Verify the proof files

These files support this result. Open a file to inspect the original evidence.

Proof 1 · Screenshot ↗image/png · 124 KB
Output file 1 (CSV) ↗text/csv; charset=utf-8 · 12 KB
Proof 2 · Screenshot ↗image/png · 96 KB
Output file 2 (CSV) ↗text/csv; charset=utf-8 · 1 KB
File fingerprints (SHA-256)

A fingerprint identifies the exact file used for this result.

Proof 1 · Screenshotab879537b715b5cbe107f0423cd459086352f9f3a6d795a42b4441c17b7d6641
Output file 1 (CSV)235736f9d19d1d66540a27b65eaaa48d24e4f2e3dd41f67244f7d3fab9f34d5e
Proof 2 · Screenshotda2c58697d6a76ada007b2fe04e0ffd994c1b37be1f9fae3958cb0178e0eab9e
Output file 2 (CSV)204e0aab003f62d9a9c4f3e38061fa48fb6537994ce5b6dbdddbb9722b2f36de