Hot, warm, cold. One engine.
Automatic tiering keeps hot data on NVMe with many parallel IO queues and moves cold data to object storage. One query surface over all of it.
-- nothing to configure: tiering is automatic SELECT * FROM orders WHERE placed_at < now() - INTERVAL '2 years';