That would create an explosion of code to handle edge cases that should never happen when interacting with the DB, or worse, pretending everything's alright and

That would create an explosion of code to handle edge cases that should never happen when interacting with the DB, or worse, pretending everything's alright and letting everything blow up in your face later.