It's not just the pipe that makes it bad for water applications. The valves, the transitions to real water piping, not to mention the birth defects. Ha
It’s fine for water applications outside the foundation.
We’ve proved this with years of success.
We have services here in PVC sch 40 from the early 70’s when it started being used and are still in service.