Well, iirc, thc and cbd aren’t what you’d call water soluble.

So you wouldn’t get much in regular water, but you might get a little more in a soda what with the various other chemicals involved. Thing is, I think the acidity would break the two main weed products in vapes into junk. But I don’t have enough chemistry in my brain run be sure.

So I suspect that what you’d end up with is crappy tasting soda that picked up the other components of the vapor.