Well, buried in your comment is the assumption that the alternative must be equally flexible, and I disagree.
Flexibility is often the cause of data loss at these companies, see "sorting a column but not the whole table" case for example.
People hate constraints, but constraints are exactly what we need to maintain data integrity. If convenience is more important, be my guest -- but I'll quit the moment they're asking me to fix an Excel table. (A bit of an exaggeration, but you get the point.)
Flexibility is often the cause of data loss at these companies, see "sorting a column but not the whole table" case for example.
People hate constraints, but constraints are exactly what we need to maintain data integrity. If convenience is more important, be my guest -- but I'll quit the moment they're asking me to fix an Excel table. (A bit of an exaggeration, but you get the point.)