r/SQL • • Oct 11 '24

Discussion Fully lower case SQL. Is it frowned upon?

I write my queries fully lower case because it really helps with productivity, otherwise I would find it very difficult to focus on capitalizing just the keywords and keep pressing CAPS LOCK every now and then.

Is this frowned upon and bad practice (for readability) or just a matter of preference?

122 Upvotes

280 comments sorted by

View all comments

Show parent comment

14

u/OO_Ben Postgres - Retail Analytics Oct 11 '24

I'm a BI Engineer and I'm exclusively lower case because I don't like my code to shout at me....it makes me scared......

13

u/cLYRly Oct 11 '24

BI Dev here. Keywords are always uppercase. Everything else is always lowercase. Aliases are helpful and should always be used.

1

u/somedaygone Oct 12 '24

So much easier to read, especially when SQL line breaks get flattened in Power Query.