SQL, full‑text, vector, & hybrid search, on Parquet.

-- one query: hybrid search + SQL filters

SELECT   _id, title, score
FROM     hybrid_search(                       -- FTS + vector, fused by RRF
           'logs', 'body', 'disk full',       --   the text side
           'embedding', :q, 50                --   the vector side, top 50
         )
WHERE    level = 'error'                      -- pushed-down filter
  AND    ts > now() - interval '24 hours'     -- on the same pass
ORDER BY score DESC                           -- one fused ranking
LIMIT    10;

-- a ranked search is a relation: join it, group it, aggregate it

SELECT   s.team,
         count(*) AS hits,                    -- rows per team
         avg(h.score) AS relevance            -- mean fused score
FROM     hybrid_search(                       -- the same hybrid search
           'logs', 'body', 'disk full',
           'embedding', :q, 1000
         ) AS h
JOIN     services s ON s.id = h.service_id    -- a plain table
WHERE    h.ts > now() - interval '7 days'
GROUP BY s.team
ORDER BY hits DESC;