With our latest real time information release, we’re now able to connect ChatGPT to any SQL database you have, and transmit the result of your SQL to ChatGPT, for then to have it analyse your data, answer your question, and return an answer accordingly.
However, before I start explaining the process, let’s first enjoy a screenshot 😁
What you’re looking at
The above ChatGPT answer was created by executing the following SQL
select f.title as Film, count(fa.actor_id) as Actors
from film as f
join film_actor as fa on f.film_id = fa.film_id
group by f.title
order by Actors desc
limit 10
The above SQL of course is a part of a Hyperlambda snippet, that looks as follows;
data.connect:[generic|sakila]
data.select:@"select f.title as Film, count(fa.actor_id) as Actors
from film as f
join film_actor as fa on f.film_id = fa.film_id
group by f.title
order by Actors desc
limit 10;"
.result:
for-each:x:@data.select/*
set-value:x:@.result
strings.concat
get-value:x:@.result
.:"Film "
get-value:x:@.dp/#/*/Film
.:" "
.:"Actor count "
get-value:x:@.dp/#/*/Actors
.:"rn"
return:x:@.result
The above Hyperlambda snippet again is using the Hyperlambda [strings.mixin] slot, which combines natural language text with the result of executing Hyperlambda code. Below is a screenshot of the complete training snippet if you’re interested.
Once the context is semantically matched towards the query, being e.g.
How many actors played in the movie MUMMY CREATURES?
The SQL extracts the following data;
Film MUMMY CREATURES Actor count 11
Film BOONDOCK BALLROOM Actor count 11
Film LAMBS CINCINATTI Actor count 10
Film HELLFIGHTERS SIERRA Actor count 10
Film ARABIA DOGMA Actor count 10
Film WIZARD COLDBLOODED Actor count 9
Film SUBMARINE BED Actor count 9
Film RANDOM GO Actor count 9
Film LESSON CLEOPATRA Actor count 9
Film IMAGE PRINCESS Actor count 9
Then our OpenAI machine learning functions submits the above data to OpenAI’s APIs, which then uses the above as its “real time data foundation for answering the question”, the end result being something such as follows;
There was 11 actora playing in the movie MUMMY CREATURES
In the video below I am walking you through the entire process
Pretty kick ass if you ask me 😁
