Well, my main use case would be to speed up project onboarding where I can play around with the app from user perspective and checking how my actions impact database... Could help cutting through a lot of frontend/backend layers...

If you have multiple DB snapshots and WAL enabled, theoretically you could inspect the log to see what happened inbetween. There's pg_xlogdump for that but I think it will output very raw data...