Natural Language to SQL Translation on bit.io

daniel-bitdotio · February 24, 2023, 7:34pm

We’ve mentioned this feature in social media a couple of times, but today we’re officially announcing OpenAI-Powered text-to-SQL translation. Read all about it here: AI-Powered Text-to-SQL Translation on bit.io | bit.io

In short: in the bit.io query editor, start a line with:

#!translate:text

and then type out a query in natural language. For example, you could go to this database and type:

#!translate:text
how many penguins are there on Biscoe island?

and you will receive the translation

SELECT COUNT(*) FROM penguins WHERE island = 'Biscoe';

For more details, and to learn about the open-source project we’re launching to create a state-of-the-art production prompt for text-to-sql translation, read this post on The Inner Join: LLM Prompts for Text-to-SQL Translation | The Inner Join

daniel-bitdotio · March 17, 2023, 7:55pm

We’ve been writing a lot about this topic!

Making a Production LLM Prompt for Text-to-SQL Translation introduces our open-source project aimed at providing tools for testing and comparing LLMs and LLM prompts for text-to-SQL translation.
Make ChatGPT Stop Chatting and Start Writing SQL shows how, with some careful prompting, we can get useful SQL output from ChatGPT, with all the explanatory text.
In our most recent article, LLM Prompt Testing Part 1: Comparing ChatGPT to Codex, we present a simple baseline test suite of prompts for SQL translation and compare the OpenAI Codex and ChatGPT models on those test suites.

Check out the open-source project on GitHub, and follow this feed for all our AI+Postgres writing.