watering view now uses new SQL generator