Disclosure

Transparency about links and funding, per FTC guidance.

This site is free. Some outbound links — for example to managed databases, data warehouses, or SQL courses — may be affiliate links: if you sign up through them we may earn a commission at no extra cost to you. We only link to tools we'd actually use, and a commission never changes what we recommend.

MySQL, PostgreSQL, SQLite, BigQuery, Snowflake, and DuckDB are trademarks of their respective owners; this site is an independent reference and is not affiliated with or endorsed by any of them.

No warranty. These snippets are provided as-is and use placeholder names. Test on a copy before running anything that writes or deletes — the upsert, update-from-join, and delete-duplicates recipes change data. Behaviour can vary by version and configuration; you are responsible for what you run against your database.