The chemical reactions and pathways involving any of a diverse group of vitamins that are soluble in water.