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/_sqlBeyond relational — Aito's learned ranking
Predict is already SQL — the PREDICTION() / PREDICTIONS() examples above. What has no SQL syntax is learned ranking: full-text search and recommend live in the JSON query API. Same demo data, one click to run:
searchSearch "milk"Full-text $match ranking over the analysed product name — the smart answer to “LIKE won’t search my text column”. No SQL syntax; JSON only.Open in Playground →recommendRecommend a productRank products by how well they meet a purchase goal — a recommendation, not an ORDER BY. No SQL syntax; JSON only.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.