Still Looking at Text-to-SQL? You're OUT! It's Now RAG2SQL! (Step-by-step)
TwoSetAI TwoSetAI
1.57K subscribers
8,662 views
0

 Published On Mar 13, 2024

In this episode, join Angelina and Mehdi, for a discussion about RAG2SQL or RAG2Database, which is an extension of the hot Text-to-SQL concept last year. A lot of the Text-to-SQL apps failed, why?
Check our episode out!

Who's Angelina:   / meetangelina  
Who's Mehdi:   / mehdiallahyari  

00:00 Intro
00:07 Why is talking to your database business critical?
00:45 What is RAG (retrieval augmented generation) to SQL?
00:58 Introduce Vanna
01:21 What kind of database can it talk to?
01:49 Text-to-SQL?
02:10 How's RAG-to-SQL different?
04:00 What does the RAT-to-SQL training phase do?
05:52 Is there real training done?
08:44 Step-by-step tutorial (Jupyter Notebook) of how it works with a SQLite databae
09:55 How to download a SQLite database on Kaggle
15:10 What more does it offer? (👉 shh... free UI! and more!)
15:47 Compare with DataDM
16:26 Performance
19:31 If you are a company with bunch of predefined SQL queries, what do you do?
20:10 Are challenges like loss-in-the-middle still applicable?

🦄 Any specific contents you wish to learn from us? Sign up here: https://noteforms.com/forms/twosetai-...

🖼️ Blogpost for today:
DataDM: https://open.substack.com/pub/mlnotes...
AI SQL Accuracy: Testing different LLMs + context strategies to maximize SQL generation accuracy: https://vanna.ai/blog/ai-sql-accuracy...

🔨 Implementation: Vanna AI: https://github.com/vanna-ai/vanna

📬 Don't miss out on the latest updates - Subscribe to our newsletter: https://mlnotes.substack.com/

📚 If you'd like to learn more about RAG systems, check out our book on the RAG system: https://angelinamagr.gumroad.com/

🕴️ Our consulting firm: We help companies that don't want to miss the boat of the current wave of AI advancement by integrating these solutions into their business operations and products. https://www.transformaistudio.com/

Stay tuned for more content! 🎥 Thanks you for watching! 🙌

show more

Share/Embed