Creating SQL statements out of text

Questions
1

Hi,

I don’t know if anyone can help but I though I would ask;

I am trying to create a system where a user can ‘speak’ a question (such as, ‘show me all the employees who live in Florida’) and then submit this to an application that can turn it into 'SELECT * FROM employee WHERE state = ‘Florida’.

I would be using Dragon as the ‘speech to text’ part, but from there, I’m sort of lost on how to proceed with the submission of the text and parsing out of the SQL statement.

Any thoughts or suggestions would be great,

Thanks,

Chris

2

You can use the Programmable Linguistic Interface framework to make this sort of thing:

This is really the only option unless you are interested in taking a course in Natural Language Processing.