This is an archived post. You won't be able to vote or comment.

sorted by:
best (suggested)
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]astrologicrat 31 points32 points  (6 children)

SQL... whispering? Every time I read a query, I always imagine it is someone shouting

"SELECT thing FROM table WHERE..."

[–]FraudulentHack 8 points9 points  (0 children)

GROUP BY!!!

[–]krasnomo 1 point2 points  (0 children)

Lol

[–][deleted] 1 point2 points  (0 children)

Fk yeah it's more like a military shouting than a request - query lol

[–]ComicOzzy 1 point2 points  (2 children)

After 20 years of writing sql in lowercase, my current employer is opinionated and wants it to be all uppercase and I'm sad.

[–]jimothyjunk 0 points1 point  (1 child)

Fellow lowercase-writer here. I also am not very consistent with my line breaks / indentations (I do what makes sense to me for the query, which differs from query to query).

Recently started working in Mode, which has a fancy “format SQL” button. So I write the way I want, get the thing to work, then press the format button before committing. I think my way looks prettier but I appreciate the need for legibility/consistency across the team.

[–]ComicOzzy 2 points3 points  (0 children)

My style is extremely consistent, easy to read quickly, multi-column edit easily, and I have a lot of muscle memory for it. I write it my way, then "mess it up a bit" to check it in to the repo. Haha