What is the difference between a data pipeline and a query?
A data pipeline is an automated process that moves and transforms data from sources into a destination on a schedule, while a query is a request that reads data and returns an answer. Pipelines prepare and stage data in advance; queries ask questions of data that already exists.
The two are often confused but do different jobs. A pipeline is infrastructure, it continuously extracts, transforms and loads data so that a warehouse or report has fresh, prepared data. A query is an act of asking, it reads existing data and returns a result.
Put simply:
- A pipeline is about *getting data ready* (engineering, scheduled, ongoing).
- A query is about *getting an answer* (analytical, on demand, immediate).
Most analytics stacks assume you must build the pipeline first, then query the prepared result. That front-loads a lot of engineering before anyone gets an answer.
iDBQuery collapses this gap for answering questions. It skips the build-a-pipeline-first step by connecting to your existing sources and querying them live, on demand, so a question becomes an answer in seconds without an ETL project. It still writes the SQL, joins across sources, and cites every figure to source rows, you just don't have to stand up and maintain pipelines to ask. If pipelines already feed a warehouse in your organisation, iDBQuery queries that warehouse too, so the two coexist: pipelines where you need staged data, iDBQuery for instant, cited questions.
Updated 2026-06-22