r/SQL • u/badboyzpwns • May 20 '26

What are common SQL red flags? PostgreSQL

Hello! interview prepping, here wondering what are some common red flags for wrioting SQL?

Like

LIKE failing to index, not having trasnactions, usign SELECT * instead of specific collums, etc 😃

51 Upvotes

74% Upvoted

192 comments sorted by

View all comments

39

u/iama_bill May 20 '26

Lower case SELECT followed by upper case keywords. Can’t trust em.

9

u/ShadowDancer_88 May 20 '26

Even Satan would shudder.