SQL over Infino
infino_sqlRun read-only SQL analytics with aggregates, joins, and filters, combining keyword, semantic, or hybrid search results in a single query.
Instructions
Use for structural or analytical questions — counts, GROUP BY, joins, aggregates, filtering by column value — returning result rows. The engine's search functions are callable as table-valued relations, so a single query can rank AND aggregate: bm25_search('table','text_col','terms', k) — also bm25_search_prefix / token_match / exact_match — need no embedding. vector_search('table','vec_col', {{q}}, k) and hybrid_search('table','text_col','terms','vec_col', {{q}}, k) need a query vector: put a {{name}} placeholder where the vector goes and pass embed:{"name":"query text"} — the server embeds the text and substitutes the vector in. Example: SELECT path, SUM(end_line - start_line + 1) AS lines FROM bm25_search('docs','body','error timeout', 300) GROUP BY path ORDER BY lines DESC. Read-only: a single SELECT / WITH statement; DDL/DML is rejected.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| embed | No | Map of placeholder name -> query text. Each text is embedded with the server's embedder and its vector is substituted for every {{name}} in the query — required to use vector_search / hybrid_search. E.g. {"q":"error timeout"} fills {{q}}. | |
| query | Yes | A single read-only SELECT or WITH statement. May use search TVFs and {{name}} vector placeholders. |