Aito API v2 Documentation (Beta)

Query/env/v2/api/v2/_query

Find products whose name matches a term ($match)

Same question in SQL

SELECT name, price FROM products
WHERE name @@ 'milk'
LIMIT 5

Try it in the SQL console →

Response

Click "Run Query" to execute against the read-only v2 sandbox env.

Tables: products, invoices, impressions, visits, contexts, price_history, prompts, answers, employees, glCodes, users

Beta v2 sandbox (CollectionDb / rep2) on the public aito-demo env at shared.aito.ai. Search, predict, recommend, relate, evaluate, estimate, aggregate, match and similarity are all live, and $why explains any prediction; only the vector operators ($nearest / $semantic / $cluster) are unavailable — aito-demo has no Vector column.