Most pvc is very good water pipe. The main problems I see are in thin walled pipe. Pvc comes in different grades or classes.
Class 160, 200 is a psi rating
Sdr (standard deminsion ratio the lower the number the thicker the pipe) 13, 21, 26,… sdr 21 is generaly 200 psi pipe, 26 is 160 psi and should be avoided like the plague.
Scheduled 40, 80,…
Pvc is generally a 75 to 100 year pipe as long as it is not 160 or sdr 26 pipe.