[qolop]

This isn't unique to duckdb. Almost all databases allow for sorting and joins of large tables that don't fit into memory.

[cweill]

Yes but if you're in a Jupyter notebook, you may not be directly connected to a DB. If you're using pandas, this unlocks some scalability before needing dask and a cluster.