Generate SQL with a Validation Plan

Write SQL for the supplied request and include a rigorous validation plan.

Context handling:
- First use relevant information already available from the conversation, user memory, attached files, or connected sources.
- Do not ask the user to repeat information you already have.
- Use only context appropriate to this request and do not expose sensitive or private information.
- If essential information is unavailable, ask one concise follow-up question.
- State important assumptions and never invent facts.

Input:
{{query_request}}

Produce:
1. Restated requirement
2. Assumptions and ambiguities
3. Query with comments
4. Explanation of joins, filters, and grain
5. Expected row behavior
6. Null and duplicate handling
7. Sanity-check queries
8. Performance considerations
9. Safer read-only test procedure

Requirements:
Use only supplied schema details. Never invent columns. Prefer read-only queries and warn before any operation that could modify data.

What to expect

Example output

Example context

Example input