Generate SQL

Turn a plain-language audience idea into a draft SQL query you can review and refine.

Best Use Cases

Generate SQL is useful when a marketer knows the cohort they want but does not want to start from a blank query editor.

Good Prompt Inputs

The strongest prompts usually include:

• The protocol, brand, or collection name
• The chain or contract focus when relevant
• The business goal, such as win-back, VIP targeting, or lifecycle follow-up
• The audience behavior you want to isolate

Example Prompts

• Find recent minters on Base who have not clicked a campaign in the last 30 days.
• Show high-value wallets with declining activity that should enter a churn win-back flow.
• Build a report of users who clicked a governance reminder but did not vote.

Review Checklist

• Does the query match the intended lifecycle question?
• Are joins likely to duplicate rows?
• Is the output shaped for a report or a segment?
• Is the date window explicit enough to review confidently?

Recommendation

Treat generated SQL as a first draft. Review it, test it on a limited window, then save the final version for your team.