[fy20]

My understanding of the issue with pumped well water (at least where I am) is more that you don't know how long the water has been sitting in pipes or tanks. (Open wells - with a bucket - have different issues as they are open)

The wells here are typically 50m+ meters deep, so if you have a 1 inch connection that's more than 25 litres just sitting in the pipe. For longevity you don't want to run the pump every time you turn on the tap, so there's usually a pressurised tank with another 25L or so and a pressure controlled switch in the pump.

So if you want to get 'fresh' water you first need to run 50L through the system. There's also the issue of extra minerals - the water here has a lot of iron, which turns everything red unless you have a good filter. The filters will have a low flow rate, so you need another tank to store the filtered water. Much easier to just get a RO system or bottled water for drinking :-)

50m of earth is going to produce some of the cleanest water you've ever had, unless of course there is pollution from heavy industry nearby. I know a few people who collect water daily from springs and drink that as is. If you lookup DIY water purification systems they typically have one plastic tank filled with sand and another with charcoal which filters pretty much all of the stuff out you don't want to drink.