In SQL, aggregate functions are not even functions. A function takes an argument and returns a result, and SQL's aggregate functions are applied to a collection that is implicitly created for each ...

Morel’s design philosophy of “everything is an expression” has transformed how we think about queries, making them more composable and flexible than traditional SQL. One stubborn holdout was the order...

I am pleased to announce Morel release 0.7.0, just one month after release 0.6.0.

Despite what the relational model says, some data is ordered.

SQL’s INTERSECT ALL and EXCEPT ALL operators rarely get attention, but they elegantly solve a classic math problem. The problem is computing the greatest common divisor (GCD) and least common multiple...

YouTube video by Data Council

In SQL, tables are inherently unordered, and query results remain unordered until explicitly sorted with an ORDER BY clause. In contrast, functional programming languages like Standard ML -- and by...

There are many excellent and innovative projects happening in the Rust data ecosystem. I am frequently asked whether Morel should be one of them. Thinking about this question gave me some insights int...

YouTube video by Julian Hyde

Until last week, I hadn’t thought much about DML in Morel. I knew we would support DML, of course, but I had assumed that we would just add commands analogous to SQL’s INSERT, UPDATE, DELETE commands.

A new map of cosmic expansion suggests that dark energy evolves over time, hinting that the universe doesn’t work the way we thought it did

<!– This post started as a script for a screencast.

I am pleased to announce Morel release 0.5.0. Coming fourteen months after release 0.4.0, this release contains various extensions to syntax to make the language more powerful and easy to use.

Today was my last day at Google.

YouTube video by Julian Hyde

**Apache Calcite Hybrid Meetup - February 2025** 📅 **Date:** February 20, 2025 📍 **Location:** Cloudera- 5470 Great America Pkwy, Santa Clara, CA 95054, United States **