Even if we do a version where the NPC is coughing up gallons of water, that’s effectively a save or die spell. The NPC can’t cast, fight effectively or run away.

If you allow that usage then create water becomes one of the most powerful spells in the game.