PromptMind Team at EHRSQL-2024: Improving Reliability of SQL Generation using Ensemble LLMs
This work addresses the need for accurate and reliable Text-to-SQL systems in healthcare, though it is incremental as it builds on existing LLM methods for a domain-specific task.
The paper tackled the problem of generating reliable SQL queries from text for electronic health records by proposing two approaches using large language models, achieving high execution accuracy and securing 2nd place in the EHRSQL-2024 shared task.
This paper presents our approach to the EHRSQL-2024 shared task, which aims to develop a reliable Text-to-SQL system for electronic health records. We propose two approaches that leverage large language models (LLMs) for prompting and fine-tuning to generate EHRSQL queries. In both techniques, we concentrate on bridging the gap between the real-world knowledge on which LLMs are trained and the domain specific knowledge required for the task. The paper provides the results of each approach individually, demonstrating that they achieve high execution accuracy. Additionally, we show that an ensemble approach further enhances generation reliability by reducing errors. This approach secured us 2nd place in the shared task competition. The methodologies outlined in this paper are designed to be transferable to domain-specific Text-to-SQL problems that emphasize both accuracy and reliability.