Azure Open AI: Generating SQL Statement from the Prompt and executing it
In this article, we will implement the process of generating SQL Statements from the simple English language prompt. AI Prompt is an input send to the AI model to guide its response. In a simple language we can define Prompt as a beginning of the conversation so that the appropriate response can be received. The accuracy of the response is depending on the appropriate prompt input to the model. The AI model is capable enough to understand and compile the prompt and generate response. In different context the prompt can be set in different format, e.g. Technical Prompt for expecting technical answers, Creative Prompt for expecting a story or a poem, and the Simple Prompt for simple translation. OfCourse for the accurate response the prompt must be accurate. In the Line-of-Business (LOB) applications we have the data mostly stored in the Relational Databases. To extract information from various table from database, we need to write complex queries with joins across tables (if ...