The AI Query Console is the centerpiece of Product 4 of this epic.
How it will work
Type a question in plain English: "Show me everyone who gave more than $500 last quarter and hasn't attended in 60 days." The AI parses the intent, translates it to a parameterized query against your database, runs it with your auth context (so RLS handles permission gating automatically), and returns results in a sortable table.
Safety
The AI cannot write SQL freehand — it can only request specific shapes of query against an allowlist of tables. Every query is audit-logged. Per-org rate limits prevent runaway costs.
Export and reuse
Save common queries with names. Share a query with another staff member. Export results as CSV, Excel, PDF, or JSON. Schedule a query to run weekly and email results to a recipient list.
When it lands
Product 4 of Epic 13. Tracking on the canonical implementation plan in docs/EPIC-13_Implementation_Plan.md.