The goal was to build a way for nontechnical people to query SQL databases with natural language.

Some examples:

Show users created today who are from Michigan. versus Select * from users where created='2015-10-13' and state='MI'

Show friendships between people in China and America. versus Select * from friendships f join users u1 on f.user_id=u1.user_id and u1.country='CHN' join users u2 on f.friend_id=u2.user_id and u2.country='USA'

I only built out the functionality for decently simple language structures like the above where the clauses can be decently easily extracted and matched in tables by type, name, or value type (ie. country codes).

Built With

Share this project:

Updates