Been in Mexico almost 7 years- it's common knowledge, you don't drink the tap water, ever. The destitute who can't afford bottled water might be the exception.
It's like a 0.1% damage over time effect. A few days drinking it? Fine. A few weeks? Still fine. Months? I started feeling just a bit more sick until I cut it out for filtered water.