Hacker News Reader

Can you expand on this? What is the difference between `GROUP BY` and `SUMMARIZE`?

I’m familiar with SQL, but not the artificial limitations that you’re referring to, and I’d like to better understand.

I'm guessing they're referring to the fact that typically when you use `GROUP BY` in SQL (aside from aggregate functions such as `ARRAY_AGG`), you're typically not returning a "group" of results, but a summary of the results in the group.

Exactly.

Reply on news.ycombinator.com