A Better Way to Write SQL queries for Developers

Too Long; Didn't Read

The way you structure your query, the way you write it goes a long way to communicate your intent to the fellow developer. In this article, I am going to show you a couple of styles which I have tried in past, their pros and cons and what I think is the best way to write SQL queries. The right way to use these styles makes it more readable and easier to spot the key details of your query. The mixed case was introduced to separate keyword from column and table names e.g. writing SELECT in a capital case and writing Employee in as it is, there is no benefit of using that style.