Your friend is correct. Even tap water corrodes copper and solder to a very small degree, but since it has a higher pH and lower soluability the effect takes decades to have any real effect. RODI water has a lower pH and also is stripped of dissolved solids, which makes it much more corrosive than tap water (albeit significantly less so than saltwater). If you want a whole home RO, pex should be used.