Date handling is where SQL dialects diverge most. This site puts the same task side by side across MySQL, PostgreSQL, BigQuery, Snowflake, SQLite and DuckDB, with a note on the per-dialect gotcha that silently changes the answer.
Where a dialect has no clean builtin, the recipe gives the correct, runnable workaround — nothing is faked.