Sorry, you are misunderstanding.. you can use compression fittings on water, forget about gas, you are not interested in that. The only difference in a compression fitting & a soldered fitting is that if you are cutting into a pipe that has been filled with water & you need to rejoin this pipe to newer pipe then a good idea would be to use a compression fitting. The only reason for this is because if you try & use a solder fitting, because of the water that may still reside in the pipe, as soon as you apply any solder in won`t run or `seal` because of the water in the pipe.That is why you would use a compression fitting because you can seal the joint mechanically i.e. with a pair of adjustable spanners or pump pliers & adjustable.