I’m really confused about the arguments around this, being that things like apostrophes and hyphens have special meanings in databases.

Yes, they do… But there are incredibly mature standard practices around how to store and query this type of data so that it isn’t a problem.

Hyphens and apostrophes aren’t uncommon in surnames. Is anyone suggesting banning those?