# Ask in plain English, get structured reports

Describe the delivery evidence you need, review the interpreted query, preview the result, and save it to run again whenever the question returns.

### Query review Structured preview Saved versions

**Pull requests merged without full review**  
Saved report · Version 4  
Saved  
Payments team Past 30 days Run again  
review_status:incomplete AND merged_at:last_30_days

Latest result 3 rows · Run 2 hours ago

| Repository      | PR      | Author     |
|-----------------|---------|------------|
| core-api       | #1842   | dkargatzis |
| web-app        | #927    | steliosot  |
| billing-svc    | #611    | devg       |

Saved reports retain their query and can be inspected by version

## From delivery question to reusable report

Templates can seed the prompt. Warestack shows the interpreted query for review before execution, then lets you preview and save the result.

1. Describe
2. Review query
3. Preview
4. Save

## The query is the contract

AI assists with interpretation. You can inspect the query and its assumptions before the structured result is generated.

**You asked**  
Which payments pull requests were merged without a separate reviewer in the last 30 days?

**Interpreted query**  
Editable

```sql
SELECT repository, pr_number, author  
FROM pull_requests  
WHERE team = 'payments'  
AND independent_reviews = 0  
AND merged_at > now() - 30d
```

Assumptions shown before execution  
“Separate reviewer” excludes the pull-request author. Draft and open pull requests are not included.

## Questions worth running again

Save a useful result, rerun it against current data, inspect previous versions, or export the table as CSV.

### Review compliance by team  
PRs merged without an independent review, grouped by team.  
Version 4 2 hours ago 18 rows Run

### Stale pull requests  
Open, non-draft PRs that have not been updated recently.  
Version 2 Yesterday 7 rows Run

### Review turnaround detail  
Time to first human review for pull requests in the selected team.  
Version 6 3 days ago 42 rows Run

## Frequently asked questions

### What can I ask Warestack to report on?

You can ask questions over supported delivery data such as pull requests, reviews, deployments, and governance results. The available fields depend on the sources connected to your workspace and the data represented in Warestack’s reporting schema.

### Does the AI execute a query without review?

No. AI assists with interpreting the question, then Warestack shows the suggested query for review. You can inspect or refine it before approving execution and previewing the structured result.

### Can I reuse a query after the first result?

Yes. A useful result can be saved as a report and rerun against current workspace data. Saved report outputs can be inspected by version, so repeated runs remain easy to compare and revisit.

### Can report results be exported?

Yes. Structured report tables can be exported as CSV for further analysis or sharing outside Warestack.

## Turn a delivery question into a reusable report

Start with plain language, approve the query, and save the structured result for the next time the question comes up.