Design a durable long-running query execution system

Design a system similar to Perplexity's Ask feature that reliably executes complex, long-running research queries over several hours, preserving progress so users can disconnect and return later to retrieve their results.