[cardanome]

This is a good starting point with some good sources linked: https://leslefts.blogspot.com/2013/11/the-great-medieval-wat...

By the way, this is the mainstream position among historians, it is only pop culture that hung up on the water myth.

[sophacles]

A significant portion of the examples in that link follow the form:

This person is so holy that they drink water.

The very fact that it was a sign of unusual holiness to drink water seems to undermine the point. It's like saying "in the 2020s people mostly didn't use cell phones. Look at this passage about a group called the Amish, see what I mean?".