Current logic of result linking links to the latest generated query. This apparently is not enough, parallel calls do happen sometimes, and that leads to bad linking which is very hard to correct.
Ideas:
create an ID on each sql query, and ask the LLM to pass in this ID to the chart generation tool as an input. This ID will be used to link the two (this way we know which chart corresponds to which query)
create a subgraph for chart generation that comes after an SQL query gen tool call
link bas on time (1st sql with for_chart corresponds to 1st chart, 2nd sql with for_chart to 2nd chart, etc.)
Current logic of result linking links to the latest generated query. This apparently is not enough, parallel calls do happen sometimes, and that leads to bad linking which is very hard to correct.
Ideas:
create an ID on each sql query, and ask the LLM to pass in this ID to the chart generation tool as an input. This ID will be used to link the two (this way we know which chart corresponds to which query)
create a subgraph for chart generation that comes after an SQL query gen tool call
link bas on time (1st sql with for_chart corresponds to 1st chart, 2nd sql with for_chart to 2nd chart, etc.)