Find answers from the community

Updated 4 months ago

Retry sql query engine for error handling

At a glance

The community member is asking if anyone has created or has knowledge of a "RetrySQLQueryEngine" - a tool that can retry generating a proper SQL statement if the initial statement errors out. In the comments, another community member suggests exploring a workflow example for "Text-2-sql" from the llama_index project, which may help in the same direction. The community members discuss the use of workflows in the llama_index project and the need to explore them further, but there is no explicitly marked answer to the original question.

Useful resources
Has someone created or has the knowledge of a RetrySQLQueryEngine? - the one which retries to generate proper sql statement if it errors out once?
W
d
3 comments
Not sure if there is, But I saw this workflow example for Text-2-sql which may help you with starting up in the same direction: https://github.com/run-llama/llama_index/blob/main/docs/docs/examples/workflow/advanced_text_to_sql.ipynb

You can check if the query is correct or not , if not then reform it with another event inside the workflow and test again.
@WhiteFang_Jr - Thanks
i see that Workflows are being used a lot these days by llama-index ....would need to explore them
Add a reply
Sign up and join the conversation on Discord