Assistant with text-to-SQL Performance

[SomebodySysop]

@omerk203

Show me the player with the most goals in the last 3 games

This is an easy one.

• OpenAI Text to SQL
  • Prompt Example - Natural Language to SQL
  • https://platform.openai.com/examples/default-sql-translate

Start with the above. That’s the basics. Define your schema. But as has been stressed again and again above, you’ve got to do it in a way that clearly explains to the LLM how to respond to the questions it will get.

• OpenAI Functions calling the Poor Developers Vector Database
  • OpenAI Functions Calling the Poor Developer's Vector Database
• Private Chat with CSV Data (@DevGirl explanation):
  • Private Chat with CSV data - #7 by DevGirl
• My Prompt Example:
  • How to apply user based access control check while generating SQL queries using OpenAI API using langchain? - #4 by SomebodySysop

Look at the example from above:

@rigor08

and for the question that the client might ask for example :
Can you show me all the sales orders placed by a user_1?
The SQL that must be generated is :

SELECT * FROM sale_order WHERE partner_id = 44;

Here is a case where, above and beyond the schema, you ALSO explain to the LLM:

• Queries with respect to users and sales orders will use the sale_order table
• The user id in the sales_order table is the partner_id field