Hacker News Reader

all schema changes should always be addition only

Maybe ideally, sure. In practice, in an org with multiple engineering teams: good luck enforcing that rule!

no database user has drop rights - very easily enforced