Explore more topics
Published model evaluations

Seven models generating financial SQL queries

Published 2025-04-10: 7 models on a shared SQL question set, the article does not state the number of questions. Per-query score from 0 to 1 summarized as average, median and standard deviation, plus success rate, average execution time in milliseconds and share of perfect scores. See the results, how they were measured and where the findings stop.

As of 2025-04-10

Jump to a section

TL;DR

Published 2025-04-10. Grok-3-Beta has the highest published average score (0.747) and perfect-score share (67.5%). Gemini 2.0 Flash has the highest success rate (92.5%) and fastest average execution time (1,296 ms), and Llama 4 Maverick has the lowest average score (0.565).

Published
2025-04-10
Published model rows
7
Evidence
Historical task evaluation

Follow this evaluation

SQL Query Generation Model Comparison table for seven models with average score, median, standard deviation, success rate, execution time and score distribution
April 2025: SQL query generation comparison across Claude 3.7 Sonnet, Gemini 2.0 Flash, Llama 4 Maverick, DeepSeek V3, Grok-3-Beta, Grok-3-Mini-Beta and OpenAI O3-Mini.
Step 1 of 3

Published results

Seven models generating financial SQL queries: source evidence dated 2025-04-10.

Exact model version
Grok-3-Beta
Average score
0.747
Median score
1.000
Std deviation
0.405
Success rate
90.0%
Avg execution time (ms)
1,707
Perfect score (1.0) share
67.5%
What you should see

The displayed values belong to the identified model versions and this published task, with their original metric units.

Step 2 of 3

What did this task require the model to return?

Read the tested version, task and rubric together. Check failures alongside successful answers; compare costs only within the reported unit.

2025-04-10: Seven models generating financial SQL queries
What you should see

Keep the study date and exact model ID beside the result. Do not average different tasks into one winner.

Step 3 of 3

Test a strategy with Aurora

Keep the study date and exact model ID beside the result. Do not average different tasks into one winner.

Test a strategy with Aurora
What you should see

Keep reporting dates and units beside the answer, and inspect its original citations.

Published results

Scale: 0 to 0.747 · zero baseline

Average score

  • Grok-3-Beta0.747
  • Gemini 2.0 Flash0.717
  • Claude 3.7 Sonnet0.660
  • Grok-3-Mini-Beta0.645
  • OpenAI O3-Mini0.635
  • DeepSeek V30.617
  • Llama 4 Maverick0.565

Scale: 0 to 1 · zero baseline

Median score

  • Grok-3-Beta1.000
  • Gemini 2.0 Flash1.000
  • Claude 3.7 Sonnet1.000
  • Grok-3-Mini-Beta1.000
  • OpenAI O3-Mini1.000
  • DeepSeek V31.000
  • Llama 4 Maverick1.000

Scale: 0 to 92.5 % · zero baseline

Success rate

  • Grok-3-Beta90.0%
  • Gemini 2.0 Flash92.5%
  • Claude 3.7 Sonnet75.0%
  • Grok-3-Mini-Beta72.5%
  • OpenAI O3-Mini72.5%
  • DeepSeek V375.0%
  • Llama 4 Maverick62.5%

Scale: 0 to 67.5 % · zero baseline

Perfect score (1.0) share

  • Grok-3-Beta67.5%
  • Gemini 2.0 Flash55.0%
  • Claude 3.7 Sonnet57.5%
  • Grok-3-Mini-Beta60.0%
  • OpenAI O3-Mini57.5%
  • DeepSeek V352.5%
  • Llama 4 Maverick52.5%

7 models on a shared SQL question set, the article does not state the number of questions. Published 2025-04-10. Values retain their original units and grading scale.

See the complete published results

Scroll sideways to compare all columns. Select a heading to sort.

Grok-3-Beta0.7471.0000.40590.0%1,70767.5%
Gemini 2.0 Flash0.7171.0000.39292.5%1,29655.0%
Claude 3.7 Sonnet0.6601.0000.45575.0%2,00357.5%
Grok-3-Mini-Beta0.6451.0000.45972.5%1,59360.0%
OpenAI O3-Mini0.6351.0000.46472.5%8,85457.5%
DeepSeek V30.6171.0000.46075.0%26,89252.5%
Llama 4 Maverick0.5651.0000.48862.5%1,98652.5%

7 models on a shared SQL question set, the article does not state the number of questions. Published 2025-04-10. Values retain their original units and grading scale.

Task and tested input

Generate SQL queries that answer natural-language financial questions over NexusTrade's stock data.

  1. Instruction in brief (task summary)

    Generate a SQL query for each financial question in the evaluation set. The article does not publish the evaluation questions or prompt. It points readers to a separate SQL evaluation article for the testing method.

How the runs worked

7 models on a shared SQL question set, the article does not state the number of questions

SQL query generation evaluation for NexusTrade's financial data. The article links its separate SQL evaluation write-up for the testing method

  1. Step 1

    Run each of the seven models over the same set of SQL generation questions.

  2. Step 2

    Score each generated query from 0 to 1 and record whether it succeeded and how long it took to execute.

  3. Step 3

    Summarize average, median and standard deviation of scores, success rate, average execution time and the score distribution per model.

How to read the measurements

  1. Grading and valid output

    Each query receives a 0 to 1 score. The table reports the distribution in buckets 0.0-0.2, 0.3-0.5, 0.6-0.7, 0.8-0.9 and 1.0. The grader is not described in this article.

  2. Cost

    The article publishes no per-model cost.

  3. Time

    Average execution time in milliseconds per model, from 1,296 ms (Gemini 2.0 Flash) to 26,892 ms (DeepSeek V3). The article does not define whether this includes model generation time.

Why this model was selected

The article's walkthrough selected Grok 3 Mini Beta in the NexusTrade model settings, and states that this choice is distinct from the top-scoring Grok-3-Beta in the table.

See the published results

SQL Query Generation Model Comparison table for seven models with average score, median, standard deviation, success rate, execution time and score distribution
April 2025: SQL query generation comparison across Claude 3.7 Sonnet, Gemini 2.0 Flash, Llama 4 Maverick, DeepSeek V3, Grok-3-Beta, Grok-3-Mini-Beta and OpenAI O3-Mini.

This image was published with the 2025-04-10 article. Read the source for the full test procedure and every result it reports.

Sample and scope

This April 2025 article publishes the results table without the question count, grader or prompt. Those are described only in a separately linked article.

Every model has a median score of 1.000, so the averages are driven by the share of low-scoring queries (0.0-0.2), which ranges from 22.5% to 42.5%.

The exact DeepSeek V3 snapshot is not named, and the Grok 3 beta models and other versions have since been replaced.

The April 15, 2025 GPT-4.1 article republishes these seven rows with identical values and adds four more models.

Read the original evidence

Continue exploring

Discussion

Sign in or create a free account to join the discussion.

No comments yet.

Aurora · AI research assistant

Try this in Aurora

Edit the request, then open it in Aurora. You choose when to send it.