Not to deter discussion of the main question, but the idea that beer replaced water for safety is a myth that u/idjet discussed in this comment.