Stopping HA from adding "Switch" and "Level" to the friendly names of my Z-Wave devices

As others have mentioned before, HA is appending “Level” and “Switch” to the generated friendly names of Z-Wave devices. It’s totally inappropriate (IMHO), and since I have almost a hundred devices already, I really do not want to have to go in and customize each one.

I’ve picked device names such that they will be good for use with Alexa via the emulated_hue component, and I don’t want to have to customize those names, which is why this matters to me.

So, first question: can I stop this behavior? It seems rather pointless to me. Second question: how to get rid of the extra word on the name, without having to re-enter 100 devices? Can I access and update the HA database directly, with a SQL client?