We just shipped 8.9 which supports updatable views. You can now have a view that points to your desired table, then prepare a new table with modified data, and ALTER the view to point to the new table. You can both read and update the data (within limits) via the view name, which can stay the same every day.
This approach should satisfy Erica’s original requirement from May '22. Subsequent queries on the view will have to recompile after the ALTER but for most apps that won’t be a problem.