Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representation

Citations Over TimeTop 1% of 2019 papers

Abstract

We present a neural approach called IRNet for complex and cross-domain Text-to-SQL. IR-Net aims to address two challenges: 1) the mismatch between intents expressed in natural language (NL) and the implementation details in SQL; 2) the challenge in predicting columns caused by the large number of outof-domain words. Instead of end-to-end synthesizing a SQL query, IRNet decomposes the synthesis process into three phases. In the first phase, IRNet performs a schema linking over a question and a database schema. Then, IRNet adopts a grammar-based neural model to synthesize a SemQL query which is an intermediate representation that we design to bridge NL and SQL. Finally, IRNet deterministically infers a SQL query from the synthesized SemQL query with domain knowledge. On the challenging Text-to-SQL benchmark Spider, IRNet achieves 46.7% accuracy, obtaining 19.5% absolute improvement over previous state-of-the-art approaches. At the time of writing, IRNet achieves the first position on the Spider leaderboard. * Equal Contributions. Work done during

Related Papers

• → SQL+i: Adding temporal indeterminacy to the database language SQL(1996)4 cited
• → How Do the Engineer Students Learn the SQL Language?(2014)2 cited
• → Conversion of Natural Language to SQL Query(2023)
• → The implementation of a functional query language front-end to a relational database system. Available in 2 volumes.(1989)
• Interactive Sql on the As/400(1995)