MQL – Client and Server to query your DB in natural language

Re:MQL – Client and Server to query your DB in natural language by dragonwriter on Monday April 08, 2024 @11:53AM (#39970947)

> There's no way for a model to correctly interpret the meaning of every column in a real world database using the `information_schema` alone.

Why would text-to-sql be limited to information_schema alone? Human analysts would use additional documentation, why wouldn't an LLM-based text-to-sql system?

[ Parent | on HN ]

Re:MQL – Client and Server to query your DB in natural language by mritchie712 on Monday April 08, 2024 @12:26PM (#39971313)

I should have clarified. There's a large number of apps that are:

1. taking info strictly from SQL (e.g. information_schema, query history)

2. taking a user input / question

3. writing SQL to answer that question

An app like this is what I call "text-to-sql". Totally agree a better system would pull in additional documentation (which is what we're doing), but I'd no longer consider it "text-to-sql". In our case, we're not even directly writing SQL, but rather generating semantic layer queries (i.e. https://cube.dev/).

[ Parent | on HN ]