(no title)
brochington | 3 years ago
This makes sense. Are there any specific examples of products that you have used that you had to do this?
> ...selecting lists with plural nouns and individual records with singular nouns...
Yes, this is for sure a failure case. I believe I have some means to work around this, fwiw.
> if I'm going to learn a structured language anyway, I would usually prefer to learn the underlying language, and not an imperfect abstraction.
I feel like I get what you are saying here, but some more concrete examples would help. Is there a "structured language" you are referring to?
toast0|3 years ago
Applescript is sold as a natural english like language, but it's really not. At least it's well documented.
Voice assistants are more like your product. Ask it a question, get something. But you have to ask them to do things in very particular ways or you don't get what you want. And there's usually zero documentation.
As an interface to SQL, your product is going to have to let me specify pretty specific relations, and that's going to take pretty specific words, IMHO. Think about how a user would ask for an inner join vs a left join vs a cross join.
Some ORMs have a pretty similar issue, where you learn an entirely different way to formulate queries, that ultimately get turned into SQL, but I'd rather work to understand SQL than to understand an abstraction over SQL (unless it gives a singificant benefit).