Is it possible to use the new Assistants API to answer questions in a SQL database? For example, take the default-sql-translate example and use it in an assistant to answer questions, not just generate SQL queries?
Good question, interested too =)
There are only 2 ways of doing this.
First, as you said, is creating a Query, so you can run in it in your site
Second, give the Assistant a readable file of your DB so the assistant can return the result directly.