It accepted the natural-language request but only ranked customers by total spend, so it did not fully understand the combined 'order the most and spend the most' intent.
What was measured
Plain English Query Handling
Can the tool understand business questions without SQL?
decisive for this rankingtransformation
This is the core of the ranking: the tool must understand a business question without the user writing SQL. (3 of 3 judges)
What was given, what came back
Test input: Best customers with unpaid-order and payment-method follow-ups · text · group: live-database-plain-english-queries
Input — what we sent
The exact prompt
Who are my best customers — the ones who order the most and spend the most? Follow-up 1: For the top 3 from that list — do any of them have unpaid orders? Follow-up 2: What payment methods do these top 3 usually use?
A conversational multi-table customer analysis with follow-up questions. It asks for the best customers by both order volume and spend, then drills into unpaid orders for the top 3 and their usual payment methods. Designed to test ranking logic, join-heavy analysis, and follow-up context retention.
Why this input is hard
- · ambiguous business term interpretation
- · multi-table joins
- · aggregation and ranking
- · follow-up context retention
- · scoping to a selected subset
- · payment behavior analysis
Output — unretouched
Also checked on this input — same tool, 4 other criteria
Ambiguity Handling✗ FailedIt did not clarify the ambiguous 'best customers' wording; it silently chose spend-based ranking and ignored the order-frequency part of the question.Business Insight✓ WorkedIt adds useful interpretation by flagging Rahul Sharma's unpaid $2,199 order, noting it had been confirmed but unpaid since April 2025, and linking his payment methods to the issue as likely an oversight rather than a pattern.Follow-Up Context✓ WorkedIt retained the top-3 customer context across both follow-ups, answering unpaid-order and payment-method questions for the same three customers from the initial list.Result Readability✓ WorkedIt returns a ranked table with order counts, total spend, and average order value that is straightforward to read and scan.
Provenance
- Observation
- 736c4cc8-4b83-445e-b321-4bf1c78cd426
- Evidence run
- af2abc96-3311-484b-a19d-854a2fdd2bf3
- Study
- Query Live Databases Using Plain English with AI
- Research task
- 86b9y6c99
- Tested at
- not recorded
- Source
- first-party
- Evidence state
- verified
- Proof shown
- input + output shown
- Cost / latency
- not captured
- Repeat run
- not captured
- Tester
- not captured
The last three rows are honest blanks, not placeholders — our capture has no field for them yet.
Query this
get_evidence({
tool: "definite",
scenario: "live-database-plain-english-queries"
})MCP · mcp.aidemos.com/api/mcp
Free with attribution.
Same input, same check — 5 other tools
measured on Plain English Query Handling
AskYourDatabase✓ WorkedIt can interpret informal ranking language like 'the ones who order the most and spend the most' and launch the analysis directly.Basedash✓ WorkedIt correctly handled a conversational, multi-part customer question without requiring SQL, producing two rankings plus follow-up answers.Draxlr✓ WorkedIt accepted the informal best-customers request and both follow-up questions across the three-turn conversation.FutureSmart NL2SQL Agent✓ WorkedAccepts the best-customers question in plain English and returns a ranked answer without requiring SQL from the user.Querio✓ WorkedHandles an informal conversational request and splits 'order the most' and 'spend the most' into two separate ranking dimensions instead of guessing.
This evidence is published in
From the same study (page rebuilt from a later run)
Real inputs and real outputs, no retouching · every cell queryable via API & MCP · aidemos.com