Database Queries / Data Explorer / Source Control / Non-Live Instance?

This absolutely something we do for our Enterprise plans. For business/standard plans best we can do is offer you a discount on a second standard instance, but the cost is high and stuff would not be magically replicated.

If costs are a concern I recommend you download backups as needed from the admin UI.