Year: 2023
Type: conference-paper
Abstract: Recently Large Language Models (LLMs) have been proven to have strong abilities in various domains and tasks.We study the problem of prompt designing in the text-to-SQL task and attempt to improve the LLMs' reasoning ability when generating SQL queries.Besides the trivial few-shot in-context learning setting, we design our chain-of-thought (CoT) prompt with a similar method to schema linking.We provide a method named ACT-SQL 1 to automatically generate auto-CoT exemplars and thus the whole process doesn't need manual labeling.Our approach is cost-saving since we only use the LLMs' API call once when generating one SQL query.Furthermore, we extend our in-context learning method to the multi-turn text-to-SQL task.The experiment results show that the LLMs' performance can benefit from our ACT-SQL approach.Our approach achieves SOTA performance on the Spider dev set among existing in-context learning approaches.
Institution: Shanghai Jiao Tong University
Language: English
Topic: Topic Modeling
Subfield: Artificial Intelligence
Field: Computer Science
Domain: Physical Sciences
Open Access status: hybrid
Awards: G4522318017, G6457581723, G8721642152
OpenAlex ID: W4389519829
