In a attempt to get out of my not-blogging rut, I wrote a little SQL Tips and Tricks post, focusing on some "friendly" additions to the query syntax that DuckDB has introduced over the last few years and Snowflake has adopted as well.
I cover the following keywords.
group by all- terminal commas (this is not a keyword)
count_ifsamplevalues
So that I could use interactive queries, I wrote it as an Observable Notebook, the fantastic Javascript focused live coding platform where DuckDB comes standard. In addition to the I've smuggled in a few opinions about SQL style. Check it out.