How we are using function calling to enable free text search over a relational database

Learn how function calling enables free text search over SQL databases, transforming structured data into conversational queries. This talk showcases practical approaches for rich data exploration.

Overview

RAG based techniques work well when for free text search because you can use embeddings to compare the input search text vs. whats in the database. When we built Doculy (over 2 different ideas), we faced the same problem but for structured data in a SQL database. 8-10 months ago, we had enabled text to sql and the approach we took a couple of months ago was using openai function calling with a defined schema and having it generate the right SQL.

Tech stack