we (https://www.definite.app/ https://www.definite.app/) do this. The SQL generation works well out of the box and works better as you update the semantic laye

we (https://www.definite.app/ https://www.definite.app/) do this. The SQL generation works well out of the box and works better as you update the semantic layer. The semantic layer includes things like joins and measures (e.g. aggregate functions) that you'd want standard definitions for. For example, you don't want an LLM creating a definition for MRR on the fly. All the semantic definitions are plain SQL. quick demo: https://www.loom.com/share/a0d3c0e273004d7982b2aed24628ef40?t=27&sid=84351346-b644-40b5-a30f-ceb065b62027 https://www.loom.com/share/a0d3c0e273004d7982b2aed24628ef40?...