Yeah, we've been working on this problem a good bit and I think text-to-sql is a dead-end for analytical questions.
We (https://www.definite.app/) ended up abandoning text-to-sql in favor of answering questions with a semantic layer (which LLM's are far more effective against).
We (https://www.definite.app/) ended up abandoning text-to-sql in favor of answering questions with a semantic layer (which LLM's are far more effective against).
https://www.loom.com/share/a0d3c0e273004d7982b2aed24628ef40