• Blog
  • Docs
  • Pricing
  • We’re hiring!
Log inSign up
alexwein

alexwein

alexBlogs

me writing about things maybe
Remix of stevekrouse/markdownBlogStarter
Public
Like
alexBlogs
Home
Code
8
other-posts
2
posts
9
Layout.tsx
README.md
about.md
analytics.ts
H
index.tsx
robots.txt
Branches
4
Pull requests
Remixes
1
History
Environment variables
1
Val Town is a collaborative website to build and scale JavaScript apps.
Deploy APIs, crons, & store data – all from the browser, and deployed in milliseconds.
Sign up now
Code
/
posts
/
2025-12-24-five-friendly-sql-tips.md
Code
/
posts
/
2025-12-24-five-friendly-sql-tips.md
Search
12/25/2025
Viewing readonly version of chart-games branch: v7
View latest version
2025-12-24-five-friendly-sql-tips.md

Five Cool Little Bits of "Friendly" SQL for wrangling data in DuckDB (or Snowflake)

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.

  1. group by all
  2. terminal commas (this is not a keyword)
  3. count_if
  4. sample
  5. values

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.

https://observablehq.com/@a-lexwein/five-cool-little-bits-of-friendly-sql

FeaturesVersion controlCode intelligenceCLIMCP
Use cases
TeamsAI agentsSlackGTM
DocsShowcaseTemplatesNewestTrendingAPI examplesNPM packages
PricingNewsletterBlogAboutCareers
We’re hiring!
Brandhi@val.townStatus
X (Twitter)
Discord community
GitHub discussions
YouTube channel
Bluesky
Open Source Pledge
Terms of usePrivacy policyAbuse contact
© 2026 Val Town, Inc.