Jason Haley

Ramblings from an Independent Consultant

Study Notes: Text-to-SQL Code Sample

Yesterday I posted my notes from this week’s study topic of Text-to-SQL, which if you haven’t read it - provides more information and resources about the topic. In this entry I want to walk through a code sample I put together after playing with a few samples this week.

Where To Get The Code

The code for this entry is in my GitHub repo semantic-kernel-getting-started under the samples/demos/Text-to-Sql directory.

Github Folder

Originally I considered making this a review of the NL2SQL code sample, but I ended up needing to make some changes to it, so I just copied over some of their code for my sample - that is why the nl2sql.library project is there (also there is a Nl2Sql folder in the TextToSqlConsole project with some other files from their repo). If you are looking into Text-to-SQL, I highly recommend taking a look at their sample.

Posted by Jason on Saturday, July 6, 2024

Study Notes: Text-to-SQL

This week I’ve been researching Text-to-SQL (also known as Natural Language to SQL), below are my study notes to compile all the resources I’ve found on the topic to date. There is also a corresponding blog entry that walks through a code example.

NOTE: I am approaching this topic specifically looking at how it can be used to extend usage scenarios in a RAG application.

Background

Text-to-SQL (or Natural Language to SQL) is a pattern where the objective is to have an LLM generate SQL statements for a database using natural language.

Posted by Jason on Friday, July 5, 2024

FEATURED TAGS
ai assistants api azd azure azure ai search azure sql career chainlit container apps copilot copilot studio ef core entity framework core eshopsupport series evaluations function calling graph rag hands-on-lab langchain learning local rag series micrsoft build announcements neo4j ollama openai pc build personal update phi4 presentation python rag rag demo series semantic kernel semantic kernel hello world series sql sql server study notes series text-to-sql vpn
ABOUT ME
avatar

Jason is an experienced developer and solutions architect focused on helping companies provide real business value with custom software development using the Microsoft stack of technologies. This includes C#, .NET, Azure and AI services. In 2024, Jason was awarded a Microsoft MVP in AI - highlighting his latest focus on AI and specifically Generative AI technologies in real world business applications. The prior seven years, he was a Microsoft Azure MVP.

Let's work together to find solutions that fit your needs. Reach out today to discuss how I can support your goals—I'm here to help!

Jason Haley MVP