LLM for data analytics: 3 main text-to-sql architecture patterns

Althrough, already today SQL AI agents can be effective for very limited and well-defined use-cases, text to sql has a long way to go to replace data analysts and similar professionals.

In the below video I describe the three main architecture patterns when it comes to building a text to sql solution.