Sqlpro query against multiple databases how to#
Sqlpro query against multiple databases pro#

Must discriminate across multiple schemas (in order to support multiple data-sources or to decompose a large schema).

Prompts cannot be hardcoded to a specific database schema or platform.

Injecting data into the prompt-frame is also a non-starter (due to the token limit).

Synchronizing an existing database to vector-storage is a non-starter as there is no desire to introduce consistency considerations or any type of data-movement.

Some basic principles that informed our approach: Let’s dive right in, check out the video below to view the sandbox in action. We will share our approach, learnings and some best practices. While alternative approaches such as local models or semantic search services exist, the focus here is to zoom into the natural abilities (and limitations) of GPT-4 to produce relevant SQL queries. This has been an area of interest for years ( WikiSQL, Spider, etc.). We are excited to share this sandbox that enables you explore the capabilities of LLM to generate SQL queries (or SELECT statements): NL2SQL. Any hints or help in the right direction would be great.We’ve heard from many in the community who want to use Semantic Kernel to query their relational database using natural language expressions.

Sqlpro query against multiple databases how to#

So in summary I am not sure how to run these queries in series and to have the results be returned on separate lines. I would like to run these two queries (in series) and get results in a table that might look like: Which returns the following results in a table:

I would like to run that query again with only one change to the data(the variable): Which returns results in a table that look like this:ĭAM | Product_Vendor_Count | Detail_Vendor_Count | Total | Select Field128, COUNT(Field167) as Detail_Image_Count from file inner join keyword1 on file.FileID = keyword1.FileID inner join path on file.PathID = path.PathIDĪnd (keyword1.Field167 like CONCAT('%', '%') or keyword1.Field32 like CONCAT('%', '%')) and keyword1.Field128 = 'Detail Image')Īnd (keyword1.Field167 like CONCAT('%', '%') or keyword1.Field32 like CONCAT('%', '%')) and keyword1.Field128 = 'Detail Image'ĪND (FROM_UNIXTIME(CreateDate) between '' AND ''))) OR (path.Path like CONCAT('%/', '/%') and file.Online=1 and file.Dir =0 and keyword1.Field28 like '%Vendor%'Īnd (keyword1.Field167 like CONCAT('%', '%') or keyword1.Field32 like CONCAT('%', '%')) and keyword1.Field128 = 'Product Image'ĪND (FROM_UNIXTIME(CreateDate) between '' AND ''))

Where (path.Path like CONCAT('%/', '/%') and file.Online=1 and file.Dir =0 and keyword1.Field28 like '%Vendor%'Īnd (keyword1.Field167 like CONCAT('%', '%') or keyword1.Field32 like CONCAT('%', '%')) and keyword1.Field128 = 'Product Image') (select Field128, COUNT(Field167) as Product_Vendor_Count fromįile inner join keyword1 on file.FileID = keyword1.FileID inner join path on file.PathID = path.PathID (select Product_Vendor_Count, SUM(Product_Vendor_Count) as Total from Select as DAM, Product_Vendor_Count, SUM( Total - Product_Vendor_Count) as Detail_Vendor_Count, Total from Ideally I could build a large multiple query that would return all of the results on separate lines.

I currently have the following query that I would like to execute and then change some of the data and execute again. My question is around how to execute multiple queries and return the results on separate lines.

Sqlpro query against multiple databases pro#

I am a very novice MySQL user and utilize the Sequel Pro application for OS X to run queries against a MySQL database v.5.1.30.