I love GearSkeptic, and agree that there is much to learn from his deep dives. His chart of water filter performance is priceless. (TLDR: Sawyer really is best.)
However, I also agree that his conclusions do not always include everything that is important.
For example, electrolytes are simpler than his details. (My approach: Everyone should supplement magnesium. Salt to taste. Mountain House may not be so bad if you’ve been sweating, for example. Add some potassium (No Salt or 50-50 blends). Gatorade Zero is cheap and reasonably balanced if you eat salty snacks; I add 3/8 tsp (2g) salt per liter if I don’t plan to eat salty food.)
Regarding pasteurization, be aware that it is NOT as good as sterilization. When dealing with common bacteria in dairy, for example, pasteurization slows growth rates sufficiently to extend refrigerated shelf life. But pasteurization does NOT kill all of the harmful bugs you could find in an unknown water source.
TLDR: Pasteurization might be sufficient for melting fresh snow or water from a good-looking spring, but I would definitely boil lake water. Or use chlorine dioxide tablets.
(Maybe Steripen if you trust invisible things that you cannot test whether or not they have done the job. It should be fine, but I know that chlorine dioxide-treated water is germ-free. Possibly both to reduce the ClO2 waiting time for cryptosporidium spores.)