  The increasing volume of data stored in relational databases has led to the
need for efficient querying and utilization of this data in various sectors.
However, writing SQL queries requires specialized knowledge, which poses a
challenge for non-professional users trying to access and query databases.
Text-to-SQL parsing solves this issue by converting natural language queries
into SQL queries, thus making database access more accessible for non-expert
users. To take advantage of the recent developments in Large Language Models
(LLMs), a range of new methods have emerged, with a primary focus on prompt
engineering and fine-tuning. This survey provides a comprehensive overview of
LLMs in text-to-SQL tasks, discussing benchmark datasets, prompt engineering,
fine-tuning methods, and future research directions. We hope this review will
enable readers to gain a broader understanding of the recent advances in this
field and offer some insights into its future trajectory.
