Robust Python Text-to-SQL Solution

I need a text-to-SQL solution to generate complex queries, self-correct, and seamlessly query diverse data sources. It should be built in Python and be compatible with Mac.

LLM agent with RAG architecture

I want to build this architecture:
https://aws.amazon.com/blogs/machine-learning/build-a-robust-text-to-sql-solution-generating-complex-queries-self-correcting-and-querying-diverse-data-sources/

Key Requirements:
- The solution should support querying from and to relational databases, CSV files, and JSON files.
- It needs to be able to create complex SQL queries from natural language input.
- The system should be self-correcting, learning from its mistakes to improve future queries.
- It should be able to query diverse data sources, extracting and presenting data in a logical format.

Ideal Skills and Experience:
- Proficiency in Python programming.
- Proven experience developing text-to-SQL solutions.
- A strong understanding of different data sources and their structures.
- Knowledge of self-correcting algorithms.
- Experience in developing solutions compatible with Mac.