I've always kind of assumed the existence of some non-adventuring spells cast by stay-at-home clerics and mages e.g. temple or guild defenses, spells specific to enchanting or crafting magic items, spells that take care of basic housework chores, and so on: the sort of things that can't or wouldn't usually be cast in the field due to time and-or material requirements.Exploring Eberron has a couple of spells specifically designed for battlefield use, and others to do tasks like cooking and cleaning. The spell lists in most D&D books are largely based around adventuring. If we have a society where magic is common, one has to assume that spells will be developed for other purposes that are not of interest to PC casters.
One of these days maybe I'll sit down and write some up just for kicks, along with elaborating many of the clerical "Ceremony" spells which also tend to fall under this umbrella.