Home → Open Source → Article

Quail: Open-Source AI-SQL Engine Cuts LLM Query Costs 27x

TL;DR

UC Berkeley researchers released Quail, an AI-SQL query engine that optimizes LLM inference for database queries, achieving 27x speedups over vLLM baselines through joint query and inference planning.

Key Points

  • Quail reduces vLLM baseline runtime from 6.84 hours to ~15 minutes on medical report queries (27.55x improvement)
  • Eliminates 40% redundant token processing by preventing KV cache eviction through intelligent scheduling
  • IMDB filter workload costs $0.37 on H100 vs $1.75 with GPT-5 nano (4.8x cheaper)
  • Supports Qwen3 4B/32B FP8 models, extensible architecture inspired by Apache DataFusion

Why It Matters

AI-SQL queries can generate millions of LLM calls per query, making them prohibitively expensive. Quail's joint query-inference planning keeps GPUs busy while minimizing KV cache waste, making AI-powered database operations practical for production workloads. This directly impacts cost-efficiency for organizations running large-scale semantic search, classification, and join operations on unstructured data.
Read the technical deep-dive

Source: fsdatalab.github.io