Two prompt rules lift Oracle text-to-SQL from 35% to 64%
A developer ran the schemagate tool with the light Gemini 2.5 Flash model on UniQL's Oracle benchmark of 1,534 questions. Adding two Oracle rules to the prompt — no AS before table aliases and quoting reserved words DATE and NUMBER — raised first-try accuracy from 35.0% to 64.5%, above the best published 49.61% from Claude Sonnet 4.5.
- First-try accuracy rose from 35.0% to 64.5% after adding two Oracle rules to the prompt
- Failed first queries dropped from 694 to 85
- 551 of 694 failures came from using AS before a table alias, which Oracle forbids
- Best published UniQL Oracle result is 49.61% from Claude Sonnet 4.5
Read next
AI