I feel this is more of a limit from single scratch pad agents Having a tasking agent refining prompts seems a much robust approach. Bonus if it can decompose

I feel this is more of a limit from single scratch pad agents Having a tasking agent refining prompts seems a much robust approach. Bonus if it can decompose the required data properly. I'm working on a world database prompt with limited success, but implementing the retrieval with prompts is time consuming and I've not much time. The idea is along the line of "translate the user question in SQL, you have a database of all known facts with a table for each entity" and then you handle the retrieval of each table data step by step. I think then you'd be able to use the postgres planner as planner, but while I've seen project of postgres retrieving data from random sources I don't remember the specifics.