SQL console

Run read-only SQL against a live Aito demo (grocery / invoicing data) right here — no setup, no client. SQL is a thin skin over the same engine as the JSON query API, so a SELECT returns exactly what its JSON query would. Pick an example or write your own; it's a read-only sandbox — no writes.

POST/api/v2/_sql

⌘/Ctrl+Enter to run · read-only demo, no writes

Beyond relational — Aito's learned ranking

The learned operations are all reachable from SQL: PREDICTION() / PREDICTIONS(), full-text @@, and the recommend(...) table function — the Predict, Search and Recommend examples above. The JSON query API is the same engine under another spelling; these cards run the same questions there. Same demo data, one click:

searchSearch "milk"Full-text $match ranking over the analysed product name — the smart answer to “LIKE won’t search my text column”. The same query in SQL is the Search example above.Open in Playground →recommendRecommend a productRank products by how well they meet a purchase goal — a recommendation, not an ORDER BY. The same query in SQL is the Recommend example above.Open in Playground →

Want the full surface, the write path, or to point your own Postgres client / connector (psql, ClickHouse, DuckDB, postgres_fdw) at Aito? See the SQL Guide.