Data & SQL21 categories
Port this query and tell me what shifts
Moving a query between Postgres, BigQuery, Snowflake, MySQL, or SQLite.
Convert this query to the target dialect. Give me a working version, then list what changed, grouped by syntax, date handling, and NULL semantics. Call out behaviour that differs even where the syntax converts cleanly: integer division, NULL ordering, DISTINCT with NULLs. Flag anything I must verify against real data. Source dialect: Target dialect: Query:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Writing and reading queries. Drafting SQL from a plain question, making an inherited query legible, and moving it between dialects.
Related prompts
Explain this query to me line by lineYou inherited a 200-line query and need to understand it before changing it.Write the query from a plain-language questionYou know exactly what you want to know and not how to express it in SQL.Solve this with a window functionYou're about to write a self-join and suspect there's a cleaner way.Port this query to another SQL dialectMoving a query between Postgres, BigQuery, Snowflake, MySQL, or SQLite.Build and explain a spreadsheet formulaWhen the lookup keeps returning N/A and the nesting is four deep.Explain this query in three sentencesSomeone handed you a query and you need the gist before you touch it.
Keep this one
Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free