ARXIV:2604.28028 · TEXT-TO-SQL · SUBMITTED 01 MAY · 15:04 UTC · FRESHNESS STALE

VerifiedSource: PDF linkedVerifiedPaperPack: citation fields availablePartialProof: unverified proof status

Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding

Smit Jivani · Sarvam Maheshwari · Sunita Sarawagi · arXiv

TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

Ship in 2-4 weeks›Score7.0Evidence unverified

Opportunity summary

Pain TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

Evidence 0 refs | 4 sources | 67% coverage

Blocker Evidence unverified

Open Build Read PDF Signal Canvas Track

PROBLEM

TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns. Yet, real-world deployment remains challenging, especially in complex or unseen schemas, due to inconsistent accuracy and the risk of generating…

METHOD

Full abstract

Large language models (LLMs) have revolutionized Text-to-SQL generation, allowing users to query structured data using natural language with growing ease. Yet, real-world deployment remains challenging, especially in complex or unseen schemas, due to inconsistent accuracy and the risk of generating invalid SQL. We introduce Template Constrained Decoding (TeCoD), a system that addresses these limitations by harnessing the recurrence of query patterns in labeled workloads. TeCoD converts historical NL-SQL pairs into reusable templates and introduces a robust template selection module that uses a fine-tuned natural language inference model to match or reject queries efficiently. Once the template is selected, TeCoD enforces it during SQL generation through grammar-constrained decoding, implemented via a novel partitioned strategy that ensures both syntactic validity and efficiency. Together, these components yield up to 36% higher execution accuracy than in-context learning (ICL) and 2.2x lower latency on matched queries.

RESULT

ScienceToStartup currently rates this 7.0/10 on the public viability pass. Together, these components yield up to 36% higher execution accuracy than in-context learning (ICL) and 2.2x lower latency on matched queries. A public repository…

WHY NOW

Text-to-SQL moved forward this cycle; last verified May 2026. Public score 7.0/10. Implementation evidence is present through a linked repository.

Continue into Read for claims, analysis, references, and neighboring papers.

Opportunity summary

Score7.0

PainTeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

Evidence0 refs | 4 sources | 67% coverage

Blockerno shell-level blocker reported

Analysis summary

TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

VerifiedSource: PDF linkedVerifiedPaperPack: citation fields availablePartialProof: unverified proof status

Competitive landscape

TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

Segment

Text-to-SQL

Adoption evidence

Public code linked for build inspection

Commercial read

7.0/10 public viability

Direct

not classified

Adjacent

not classified

Substitute

not classified

Unknown

not classified

{ "contract_version": "paper-r2", "paper_id": "80f79c28-2e56-4a12-a7f1-4f359a13d1bb", "arxiv_id": "2604.28028", "canonical_route": "/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "active_tab": "synced from current hash by the drawer client", "selected_artifact": "reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "endpoints": { "paper_pack": "/api/v1/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding/paper-pack", "build_passport": "/api/v1/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding/build-passport", "mcp_resource": "sciencetostartup://surfaces/paper-workspace" } }

{ "surface": "paper", "mode": "paper", "query": "Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding", "normalized_query": "2604.28028", "route": "/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "paper_ref": "reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "topic_slug": null, "benchmark_ref": null, "dataset_ref": null }

{ "@context": "https://schema.org", "@graph": [ { "@type": "WebPage", "@id": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding#webpage", "url": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "name": "Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding", "description": "TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.", "isPartOf": { "@id": "https://sciencetostartup.com/#website" } }, { "@type": "ScholarlyArticle", "@id": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding#scholarlyArticle", "headline": "Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding", "description": "TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.", "url": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding", "sameAs": "https://arxiv.org/abs/2604.28028", "identifier": { "@type": "PropertyValue", "propertyID": "arXiv", "value": "2604.28028" }, "isAccessibleForFree": true, "isPartOf": { "@id": "https://sciencetostartup.com/#website" }, "datePublished": "2026-04-30T15:44:34.000Z", "author": [ { "@type": "Person", "name": "Smit Jivani", "affiliation": { "@type": "Organization", "name": "Indian Institute of Technology Bombay" } }, { "@type": "Person", "name": "Sarvam Maheshwari", "affiliation": { "@type": "Organization", "name": "Indian Institute of Technology Bombay" } }, { "@type": "Person", "name": "Sunita Sarawagi", "affiliation": { "@type": "Organization", "name": "Indian Institute of Technology Bombay" } } ], "codeRepository": "https://github.com/SSLab-CSE-IITB/tecod", "additionalProperty": [ { "@type": "PropertyValue", "propertyID": "viabilityScore", "value": 7 }, { "@type": "PropertyValue", "propertyID": "researchDomain", "value": "Text-to-SQL" }, { "@type": "PropertyValue", "propertyID": "commercialReadiness", "value": "code, repo url" } ] }, { "@type": "SoftwareSourceCode", "@id": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding#software", "name": "Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding - Source Code", "description": "TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.", "codeRepository": "https://github.com/SSLab-CSE-IITB/tecod", "url": "https://github.com/SSLab-CSE-IITB/tecod" }, { "@type": "BreadcrumbList", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "Home", "item": "https://sciencetostartup.com" }, { "@type": "ListItem", "position": 2, "name": "Text-to-SQL", "item": "https://sciencetostartup.com/topics" }, { "@type": "ListItem", "position": 3, "name": "Reliable Answers for Recurring Questions: Boosting Text-to-S", "item": "https://sciencetostartup.com/paper/reliable-answers-for-recurring-questions-boosting-text-to-sql-accuracy-with-template-constrained-decoding" } ] }, { "@type": "FAQPage", "mainEntity": [ { "@type": "Question", "name": "What is the startup potential of \"Reliable Answers for Recurring Questions: Boosting Text-to-S\"?", "acceptedAnswer": { "@type": "Answer", "text": "TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns." } }, { "@type": "Question", "name": "What products could be built from this research?", "acceptedAnswer": { "@type": "Answer", "text": "Productize this as an enhancement module for existing business analytics platforms. It could be offered as a premium feature that users subscribe to for optimized performance when querying databases in enterprise environments." } }, { "@type": "Question", "name": "What are the practical use cases?", "acceptedAnswer": { "@type": "Answer", "text": "A commercial application could be a middleware service for business intelligence tools that automatically translates user inquiries into SQL queries, ensuring higher accuracy and lower latency." } }, { "@type": "Question", "name": "What industries could this research disrupt?", "acceptedAnswer": { "@type": "Answer", "text": "TeCoD could replace or enhance existing Text-to-SQL solutions by significantly improving their performance with recurring queries, potentially integrating into platforms like Microsoft Power BI or Tableau." } } ] } ] }

Competitive landscape

TeCoD improves Text-to-SQL systems' accuracy by utilizing template constrained decoding for recurring query patterns.

Segment

Text-to-SQL

Adoption evidence

Public code linked for build inspection

Commercial read

7.0/10 public viability

Direct

not classified

Adjacent

not classified

Substitute

not classified

Unknown

not classified

Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding

Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding

Claim map

Constellation map

Competitive landscape

Buzz

PDF

REFERENCES

Related Papers

Related Resources

Subscribe to the weekly brief

Build artifacts

Brief

Experiment plan

Validation checklist

Scientific founder

Translational engineer

Domain operator

GTM lead

Regulatory/clinical advisor

Timeline

Claim map

Constellation map

Competitive landscape

Buzz

PDF

REFERENCES

Related Papers

Related Resources

Subscribe to the weekly brief

Build artifacts

Brief

Experiment plan

Validation checklist

Scientific founder

Translational engineer

Domain operator

GTM lead

Regulatory/clinical advisor

Timeline