Lets jump right in with an actual question I just gave to a Hana Cloud Database:
The response I got back was correct :
Ok so you’re guessing I used ChatGPT, so it’s either hallucinating and made a lucky guess, or perhaps I pre-loaded the data (context) into ChatGPT and it just summarised the results for me.
Nope.
I utilsed OpenAI’s API’s to converted the question into SQL, the SQL was then executed on a Hana Cloud instance and the results were then further summarised by OpenAI. LangChain’s SQLDatabaseChain does most of the work.
Heres the full interaction:
Click to Enlarge
Bonus Points to anyone who noticed I ‘deliberately’ miss-spelt Australia in the question. It wasn’t a significant obstacle for OpenAI.
The SQL generated really does run in Hana:
Click to Enlarge
The data flow is approximately like this:
The sample code is here:
Github LangChainHanaSQL example
The main inspirations and references include:
So as you can see it’s now possible to ask Hana questions in Natural language.
I hope you found this glimpse of a potential future interesting.
In the next 2 blogs I explore some of the issues and potentials solutions of working with Large Lanaguage Models with sensitive Enterprise data:
Under the Hood – Text to SQL with LangChain, LLM’s and Hana
Into the SQL weeds – Fine-Tuning an LLM with Enterprise Data
What use case would you find this useful for?
