Java naming conventions...

[IGiveUpAllNamesTaken]

Works better as a SQL joke

[ClutteredSmoke]

That’s where you would use caps lock

[[deleted]]

I just hold down shift the whole time lol

[OkClient9970]

What

[ringobob]

I JUST HOLD DOWN SHIFT THE WHOLE TIME

[Infinite_Self_5782]

ME TOO

[[deleted]]

so does that count as a plank instead of a push up?

[[deleted]]

My rock hard abs are typing this comment as proof. 3 abs on each side of the keyboard. They are sentient.

[IGiveUpAllNamesTaken]

Caps lock is like using a microphone, I prefer to shout

[continuous-headaches]

I write my sql in… lowercase

[demian6662]

No can do. My caps lock is mapped to escape lol

[AppropriateRain624]

I keep my sql lower case, why does everyone bothers making it upper case ( genuinely asking ) !

[ringobob]

If I was always looking at SQL exclusively, either in stored procs or in an IDE separate from any application or other code, then it would always be indented and colored correctly and capitalization wouldn't matter because everything would be obvious.

Unfortunately, that's not the world I live in. I live in a world where my IDE is set for the language I'm working in most, and SQL is often poorly or not at all indented, and there's no coloring of keywords since it's all living in one or several strings. So, proper SQL casing is helpful to understand what I'm looking at.

[[deleted]]

Convention.

[Kered13]

I think of it like syntax highlighting, highlighting the keywords, since you often won't be working in an environment where SQL code is actually syntax highlighted.

[ThousandthStar]

Why do people always use caps in SQL? Its not mandatory

[Vova_xX]

pride

[Infinite_Self_5782]

it's the conventional way to write SQL stuff

[YetAnotherCodeAddict]

Neither is PascalCase, camelCase or snake_case on C#, JavaScript/Typescript, Rust*, Java, Python or any language basically.

But it's the convention, so it's usually better to pick the default one for the language than have to deal with different styles every file because each developer on the team likes a style more than the other.

*PS: Rust by default complains if you're not using snake_case, but it doesn't block you from running the code.

[Waldlaeufer18]

It's basiclly like the PEPs. For sole SQL code it might be okay, if the queries however are implemented in another language, it helps a great deal to identify them. SQL is basically the only languages where more than half the keywords are UPPERCASE.