I made a tool to translate English to SQL
sqlgenie-co.web.app
sqlgenie-co.web.app
But yes, the ideal setup would be to have a system that can connect to data sources and figure out the schema, etc. And for that, it needs to have on-prem. I am currently working on this.