As an avid backpacker in my youth I drank a bunch of stream/lake water, generally filtered through a product like this:
https://sawyer.com/products/sawyer-mini-filter/
These filters take out most of the bad stuff related to bacteria and protozoa, so I was safe from getting a stomach ache. But...