I recently led a RAG intro workshop at the Recurse Center, sharing here the blog post version. I couldn’t resist using Titanic, a throwback to Kaggle days. https://ezzeriesa.notion.site/My-first-text-to-SQL-RAG-pipeline-1141308b420480d5a095c5e17a967f79

@Ezzeri Esa Interesting work! Have you tried playing with multi-table queries? Something like this:

SELECT t.column_number, p.column_description
FROM dim_tickets AS t
LEFT JOIN dim_passengers AS p
ON p.passenger_id = t.passenger_id

Yes the data app allows you to enter a prompt that needs a join