Comment by qolop

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