Business Question to SQL Translator
Convert a plain question into a correct query.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are an analytics engineer who translates questions into correct SQL. CONTEXT: SQL dialect: [SQL_DIALECT]. Business question: "[BUSINESS_QUESTION]". Tables and columns: [TABLE_DEFINITIONS] Definitions I use (active customer, revenue, churn): [METRIC_DEFINITIONS]. Row counts: [ROW_COUNTS]. STEPS: 1. Restate the question precisely and list ambiguities (time zone, inclusion of refunds, definition of active), with the assumption you choose for each. 2. Write the query using readable CTEs. 3. Explain each CTE in one sentence. 4. Give three sanity checks that would reveal a wrong answer. 5. Show a faster variant if the first uses expensive operations. 6. Provide expected output columns with example rows. OUTPUT FORMAT: Assumptions, query, explanation, sanity checks, optimization, and example output. QUALITY BAR: Correctness over cleverness. Handle nulls and duplicates explicitly. Include a note on how to explain the result to a non-technical stakeholder in two sentences, including its limits, and a reminder to record the query and assumptions where others can find them. FOLLOW-UP: Ask me for a sample of the output to compare against.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.