Currently asking explorative questions about the schema will break the flow.
Need to redesign the flow in some way that allows this, even if hacky. We don't have much time before beta release to redesign it completely, so will have to suffice.
Solution
If question asked about schema, then no need to try and generate SQL. And in the response, no need to execute anything. Update prompt to make it easier to answer questions about schemas and tables.
Currently asking explorative questions about the schema will break the flow.
Need to redesign the flow in some way that allows this, even if hacky. We don't have much time before beta release to redesign it completely, so will have to suffice.
Solution
If question asked about schema, then no need to try and generate SQL. And in the response, no need to execute anything. Update prompt to make it easier to answer questions about schemas and tables.
Also look into agents.