3 ms·

I dunno... English to sql query is probably easier than English to French. You don't actually need to understand that Indiana is a place, just recognize that it

I dunno... English to sql query is probably easier than English to French. You don't actually need to understand that Indiana is a place, just recognize that it's one of those tokens that's getting stuffed into the where clause... The tough part is really probably the implicit knowledge of what the database columns are called. Is Indiana a "state" field or a substring in an address field? Depends on the database. This mixing of "soft" ml queries with "hard" requirements is a really interesting space, which I think will produce massive results if we can get it under control. It's similar to the problems in the AI dungeon master space... And probably tutoring, as well...

retrac 6y ago
> I dunno... English to sql query is probably easier than English to French. You can have substantial success in transforming English to French without understanding what is said. Some big grammar rulebooks, some dictionaries, and a few terabytes of sentence-aligned parallel texts and data on statistical colocations in the languages will get you most of the way. It's far from 100% accurate but the human brain is surprisingly good at filling in the gaps with the mangled grammar and odd turns of phrase. I'm not so sure the same is true about English to SQL query. The exact meaning of the English must be understood, in context, in order to construct the query correctly. No room for error or fuzziness. The database engine doesn't have human cognition to fall back on should the query be slightly malformed or ambiguous.