Water soluble is better for the majority of cutting, and is what I use for most machining.
However, pure oil is better for operations with high loads, such as tapping, and where you really don't want things to stick/gall, such as parting of in a lathe.