SQLore
FeaturesPricingDownloadAboutBlogContact
Start freeStart for free
SQLore
HomeFeaturesSolutionsPricingDownloadCompareFAQAboutBlogContact

SQLore © 2026

TermsPrivacyRefunds
Download for macOSDownload for WindowsSign in
  1. Home
  2. Blog

Notes On Building It

Schema linking, the SQL guard, how a result set chooses its own chart, and the parts of answering a database question that turned out harder than they looked.

7 August 2026·6 min

Choosing a chart for a SQL result, without asking the model

A question deserves an answer, not a grid of rows. But asking a language model what to draw is slow, non-deterministic and unnecessary — the result set already says what it is. Here are the rules we run instead.

Read
14 July 2026·6 min

How to set up a read-only database user for an AI tool

Whatever an AI tool promises about read-only behaviour, the durable guarantee is the one your database enforces. Here is the SQL for both engines, including the grant that silently fails to cover tables created next week.

Read
23 June 2026·7 min

Why AI-generated SQL gets joins wrong

The model knows SQL better than you do. It does not know that a customer is a row in accounts, that churn lives in subscriptions.cancelled_at, or that the two join through account_id — and that is where every wrong query comes from.

Read
30 May 2026·5 min

Text-to-SQL benchmarks do not predict your schema

A tool advertising 90% on a public benchmark is telling you about that benchmark's schema. Yours has 1,700 tables and a boolean called flag_2. Here is a five-question test that predicts something.

Read
SQLore platform

Stop Writing The
Same Three Joins

Start free, upgrade when you are asking enough questions for it to matter.

Start for freeContact sales
sqlore.com

New chat

Search chats

TODAY

Orders by month

PREVIOUS 7 DAYS

Top products by revenue

PREVIOUS 30 DAYS

Repeat customer rate

Revenue by category

Average order value

Refunds by reason

Customers by city

Cart abandonment

Slowest shipping lanes

Discount impact on margin

Inventory turnover

Order statistics

SQLoredesktopretail_db · default⌘K

Order statistics for this year

Reasoning — 2 steps, 2 queries

Total orders · Delivered · In transit · Cancelled

1 row · 10 ms

Stat

15,600

Total orders

13,942

Delivered

1,412

In transit

246

Cancelled

orders by category

4 rows · 11 ms

LineDonutBar
8,4006,3004,2002,1000
ACCESSORIESPERIPHERALSFURNITUREDISPLAYS

There are 15,600 orders in retail_db for the year to date.

  • Status: 13,942 have been delivered and 1,412 are still in transit.
  • Category: most sit in Accessories (8,420), followed by Peripherals (4,180), Furniture (2,140) and Displays (860).

Revenue by payment method

Reasoning — 1 step, 1 query

Ask about your database…

Answers come from SQL run against your database.