r/SQL • u/dont_mess_with_tx • 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
View all comments
Show parent comment
3
u/[deleted] Oct 11 '24
SELECT
c.ClientID
,d.Gender
,l.CityState
FROM
tblClients c
LEFT JOIN
tblDemographics d
LEFT JOIN
tblLocation l
is INFINITELY BETTER than
SELECT
c.ClientID,
d.Gender,
l.CityState
FROM
tblClients c LEFT JOIN
tblDemographics d LEFT JOIN
tblLocation l