Here's a walkthrough video of my deep dive into Agentic Python Pipelines that allow AI to answer complex queries by writing SQL and Python at query time. For this to work AI is given a code sandbox and guard-railed access to business and science datasets. Learn more here:
https://www.youtube.com/watch?v=1P_bsMW7j10
Does this approach solve all problems with using AI in structured data applications? Not quite. You do need a halfway-decent schema and naming system. I.e., the AI models get confused about bad naming and poor semantics just like humans !




