SQLizer: Synthesizing SQL Queries from Natural Language

Computing & Wireless : Utility Software

Available for licensing

Inventors

  • Isil Dillig, Ph.D. , Computer Science
  • Thomas Dillig, Ph.D. , Computer Science
  • Navid Yaghmazadeh, Ph.D. , Computer Science
  • Yuepeng Wang, B.E. , Computer Science

Background/unmet need

Although many end-users need to query data stored in some relational database, they typically lack the expertise to write complex queries in declarative query languages such as SQL. This software (SQLizer) presents a new technique for automatically synthesizing SQL queries from natural language (NL).

Invention Description

SQLizer is a software that can generate SQL queries from a natural language (English) description. It can therefore be used by end-users to retrieve relevant information from a relational database without having to learn any formal query language whatsoever.

Benefits/Advantages

    SQLizer is fully automatic, which means it does not require guidance from the user other than the given English description. It is also database-agnostic, which means it can be used to generate queries on different databases without any database-specific training or customization.

Features

    SQLizer is implemented in C++ and Java. It uses SEMPRE framework to build a semantic parser for query sketch generation.

Market potential/applications

Companies that work on business intelligence and analytics and/or data management and analysis.