I agree that would be easier to implement, but it violates the SSOT principle by introducing an edge case of lost database changes that have not been written to

I agree that would be easier to implement, but it violates the SSOT principle by introducing an edge case of lost database changes that have not been written to the files (for example during a system error).