Best practices for writing SQL queries

Re:Best practices for writing SQL queries by mulmen on Saturday April 10, 2021 @04:43PM (#26764972)

My editor has tab completion, it's not like you have to type every character. I prefer it for readability but it's definitely debatable.

[ Parent | on HN ]

Re:Best practices for writing SQL queries by magicalhippo on Saturday April 10, 2021 @05:22PM (#26765252)

Readability is weird heh, I'm exactly the opposite. For me long lines become a blur, so better to have a short alias.

[ Parent | on HN ]

Re:Best practices for writing SQL queries by mulmen on Saturday April 10, 2021 @05:48PM (#26765444)

I know what you mean. I think this is really a matter of readability vs comprehension. I want all the context on one line so I can understand it, even if that does technically make it harder to read that line.

This is especially a problem in huge queries.

[ Parent | on HN ]