Answer any agent question directly on Parquet.

Infino embeds functions in SQL so agents can express complex questions in a single query.

1. 1

   An agent asks a question

   How manyA count. The agent wants a number, not a pile of log lines. SQL does this with COUNT. errors last nightFilters. Keep the error-level rows and the last 24 hours. mention disk fullKeyword search. Match those exact words in the log body. Today this is a call to a search engine. or look like a capacity incidentSemantic search. Match meaning even when the log never says disk full. Today this is a call to a vector database.? Which serviceA group on the same hits. SQL GROUP BY. Today a second warehouse query after the searches return. had them, and which team owns itA join. Match each service to its owner in a second table. Today the agent looks this up in another system and stitches the answers together.?

2. 2

   It hides six jobs

   • countHow many
   • groupWhich service
   • joinwhich team owns it
   • filtererrors last night
   • keyword searchdisk full
   • semantic searchcapacity incident
3. 3

   One SQL statement runs all six

   query.sql

   SELECT   o.team, h.service, count(*) AS hits
   FROM     hybrid_search(
              'logs', 'body', 'disk full',
              'embedding', :q, 1000
            ) AS h
   JOIN     owners o ON o.service = h.service
   WHERE    h.level = 'error'
     AND    h.ts > now() - interval '24 hours'
   GROUP BY o.team, h.service
   ORDER BY hits DESC;

hybrid search →