We have our application which stores data in SQL Server.
We are exploring ways where a user types in 'What is my sale as of today or What are my July 2024 sales ’ in a chatbot or any form of UI and a SQL query is fired with the required parameters and returns the result in the chat window.
Do you have any idea how to achieve this use case?
Thanks
Welcome to the Community!
You should take a look at function calling.
Here’s the official guide and here are some worked examples including a SQL example from OpenAI’s cookbook collection.
hii @jigsm_shah are you still building the kind of application ,cause i’m building the same kind of application and would like to know more about the generation and execution of the sql queries