What is an ad-hoc query?
An ad-hoc query is a one-off, on-the-fly question run against data to answer an immediate need, rather than a saved, scheduled or pre-built report. Ad-hoc analysis is exploratory and unplanned, you ask whatever the moment requires, often to inform a specific decision right now.
Ad-hoc queries are the unplanned questions that come up constantly: 'how many orders shipped late last week?', 'which customers churned since the price change?'. They are not part of a standing report, someone needs the answer once, now.
Traditionally, ad-hoc analysis meant either writing SQL yourself or waiting in the queue for an analyst to do it, which is slow and doesn't scale. Dashboards help with recurring questions but not with the genuinely new ones.
Ad-hoc analysis is exactly what iDBQuery is built for. Anyone can type an ad-hoc question in plain language and get an immediate, cited answer across all connected sources, no SQL, no ticket, no waiting. Because it queries your live data on demand rather than relying on pre-built reports, there is no limit to what you can ask, if the data can answer it, iDBQuery can. This turns ad-hoc analysis from a bottleneck into self-service: decisions get their supporting numbers in seconds, and because every figure is cited back to source rows, those quick answers are still trustworthy enough to act on.
Updated 2026-06-22