Can I connect a SQLite database to iDBQuery?

SQLite is a single self-contained database file, and iDBQuery treats it as a standard SQL source — no server or connection string required.

• You'd connect SQLite by pointing iDBQuery at the .sqlite / .db file (an app database, an export, a local analytics file).
• iDBQuery introspects the tables and columns, applies its semantic layer to interpret naming, and adds the database to your one live queryable model.
• Ask in plain language — *"How many orders shipped last week and what was their total value?"* — and iDBQuery writes the SQL, runs it against the SQLite data, and returns a number, chart or table.

Because a SQLite file is compact and portable, it's a common way to hand iDBQuery a slice of an application's data for quick analysis. As with every source, iDBQuery cites every figure back to the exact rows so the answer is auditable, and the SQLite file can be combined in one question with a larger Postgres or MySQL database, a warehouse, or a spreadsheet — all reasoned over as one model with no pipeline. If the file holds sensitive data, the Desktop app and air-gapped deployment keep everything local so nothing leaves your machine.