Water or solvent is just the carrier of the coating left behind when the
carrier evaporates, so I'd say it will be OK.
Most fence preservers are water based and they work fine for years, even
when both sides are subject to all weathers.
I've recently worked on a pub and the bar top was stripped, then done in
water based varnish, and that has beer spilled on it continuously.