I agree. For RDS, AWS will create nightly snapshots for the production data. Then it would be up to the company to set up an additional pipeline to take that snapshot, scrub the data, and create a new snapshot which would get used by the developers. Not an easy task, but the benefits are there.

And getting the most up to date data would be the same process. Create a new snapshot, run the scrubbing process, create a new scrubbed snapshot, get the database to the developers.