How do I do ad-hoc data analysis without writing SQL?

You do ad-hoc analysis in iDBQuery by typing your question in plain language and getting a cited answer in seconds. iDBQuery writes the SQL, runs it against your live data, and shows the chart, table, and exact source rows behind every number — no query language, no spreadsheet exports.

Ad-hoc analysis usually means waiting on someone who can write SQL, or wrestling a CSV in a spreadsheet. iDBQuery removes that step entirely.

  • Ask in plain language — "What were our top 10 customers by revenue last quarter, and how did that change year over year?" iDBQuery interprets the intent, picks the right tables, and writes the query for you.
  • Get a cited answer — every figure traces back to the exact source rows, so you can verify it instead of trusting a black box.
  • Follow up naturally — "Now break that down by region" or "Exclude refunds" refines the same analysis without starting over.
  • See it rendered — results come back as charts, tables, or stats automatically, ready to drop into a report.

Because iDBQuery queries your databases, spreadsheets, and documents in place, there is nothing to export or load first. A semantic layer helps it understand cryptic column names, so even an unfamiliar schema answers cleanly. If a question needs digging — comparing periods, isolating an outlier, joining three sources — you can hand it to the autonomous Analyst agent, which investigates on its own and returns a written, cited finding. The result: the same answer a SQL-fluent analyst would produce, in seconds, with the receipts attached.

Updated 2026-06-22