Back to Talks
SQL is Dead, Long Live SQL: Engineering reliable analytics agent from scratch

SQL is Dead, Long Live SQL: Engineering reliable analytics agent from scratch

Dumky de Wilde & Mehdi Ouazza

Date
Tuesday, April 14, 2026
Time
11:45 AM - 1:15 PM
Room
Dynamicum [Ground Floor]
Tutorial PyData: Data Handling & Data Engineering
Transcription

This session is a "reality check" for AI analytics. We combine theory with engineering to answer one question: Where are the limits of Text-to-SQL? Participants will experience the frustration of a hallucinating LLMs and the satisfaction of fixing it with a realistic minimalist local setup.

Learning objectives: 1. Map the limits: Identify exactly where LLMs break (e.g., complex joins, specific business logic, non-standard schemas). 2. Bridge the gap: Learn how a semantic layer translates fuzzy English into deterministic SQL. 3. Modern architecture: Overview and hands-on on DuckDB Model Context Protocol (MCP) to give agents standard, safe tools to do analytics. 4. The verdict: Understand why SQL is becoming the "Assembly Language" of the AI era, and why you still need to be fluent in it and what is still missing to just "chat with our data".

Prerequisites: - Laptop with Python 3.10+. - Beginner SQL knowledge (joins, aggregations). - No prior AI/LLM experience required.