Put the structure of your data, a few sample rows, or both into a single text string. Craft a “prompt” to the AI with that information plus your natural language question.

Couple this with the concept of correlated-subqueries (the process of running a "child" query for each row in the "parent" resultset), and you can get pretty much anything you want with 'simple' SQL.