Re:Sqlfluff the SQL Linter for Humans
by forgetfulness on Wednesday October 06, 2021 @11:07AM
(#28774042)
Yes you can find sources advocating for leading commas and it's commonly used. I have "Google BigQuery: The Definitive Guide" on my desktop, it was written by senior Google employees involved in the steering and use of the product inside, for what it's worth, and it advocates for leading comma and SHOUTING THE KEYWORDS.
I personally disobey both recommendations (I mean, the book is worth it for other reasons) but both those conventions are very commonly used.
I meant more the the "center" layout that the commenter above was describing, it'd seem quite laborious to maintain by hand in most environments, if not using a particular one that supports it out of the box.
Re:Sqlfluff the SQL Linter for Humans
by y4mi on Wednesday October 06, 2021 @01:42PM
(#28775937)
jetbrain IDEs have it configured by default for most situations, so its generally just an auto-format away if you're actually writing sql and not embedding sql queries in some other code.
I personally disobey both recommendations (I mean, the book is worth it for other reasons) but both those conventions are very commonly used.
I meant more the the "center" layout that the commenter above was describing, it'd seem quite laborious to maintain by hand in most environments, if not using a particular one that supports it out of the box.