#18 Add DuckDB connector for local/file-backed analytics

[Anonymous]

Originally created by: intraq-dev-ai

Connector gap

WrenAI OSS supports DuckDB as an included local/file-oriented connector. IntraQ currently has flat-file upload workflows, but no DuckDB live query connector/runtime.

Evidence

WrenAI docs list DuckDB in OSS supported data sources. IntraQ live SQL execution currently supports PostgreSQL, MySQL/MariaDB, SQL Server, Databricks, and ClickHouse via apps/api/src/modules/data-source/live-sql-query-types.ts and live-sql-runner.ts.

Why this matters

DuckDB is a strong default connector for source-available/self-hosted BI because users can analyze local CSV/Parquet/JSON files without provisioning a database.

Acceptance criteria

• Add DuckDB as a selectable data source.
• Support connection/profile fields for local database files and/or file-backed tables.
• Support schema discovery, query preview, SQL Editor execution, Analyzer, and Dashboard Builder.
• Add tests for discovery, safe SELECT execution, limits, and error handling.