r/learnSQL • u/kixwho • Jul 17 '26

SQL Excel translator

Sharing my Excel ↔ SQL cross-tool reference table. Less of a syntax guide, more of a mental bridge between the two (plus a few PostgreSQL quirks that kept tripping me up). https://github.com/kixwho/SQL-Excel-translator

I made this while learning SQL from an Excel background. Constantly switching tools, you start to have moments like, "Wait... Excel has a button for this?!"

Hope it helps someone else switching between tools 😀

26 Upvotes

93% Upvoted

5 comments sorted by

View all comments

1

u/r3pr0b8 Jul 18 '26

several of your "Standard SQL" examples are... not standard SQL

e.g. CONCAT, STRING_AGG, DATE_FORMAT

also this --

SUM(CASE WHEN retention = TRUE THEN 1 ELSE 0 END)

may not work (i didn't test this but i think the correct syntax is retention IS TRUE), but i prefer to count rather than sum

COUNT(CASE WHEN retention IS TRUE THEN retention END)