Propress compression fittings which use a hydraulic press are effective enough for domestic water pipes, along with traditional solder joints.

Electrical compression fittings are excellent too, but some engineers still specify exothermic welds (cadwelding) for grounding conductors in particular.

I did a project a couple years back with a mechanical contractor that used a similar machine to the one in the video you shared, except theirs was a bit larger ;) They were welding 18” HPDE pipes together for a geothermal district energy project, we were laying some puny 2” schedule 80 conduit that was glued together with primer and cement for future fiber cables that will connect to the meters of the customers of the district energy system.

ProPress are a (high-quality) solution but IIRC for copper piping.

PEX water piping expands and fails less(than galvanized) in freezing temperatures. This is the current accepted replacement for galvanized water piping.

PVC piping is also used but doesn't develop the pinhole leaks that galvanized steel pipe does. However it can fatigue and develop leaks.

AFAIK all can be patched with, ta-da, pipe clamps!

But most water leaks, especially in winter freezing, arise in old rusting galvanized steel piping. I'm not a plumber but I was a condominium association officer and president and so got to choose, watch and pay for repairs.

We had only copper, PVC and galvanized water lines. The copper was well underground and so failed only once in 20 years due to age and a nearby tree shifting the pipes. The PVC never failed but we had almost none. The galvanized pipe was a guaranteed failure every winter unless we took serious precautions when temperatures dropped.