Molecular spectroscopy of aqueous solutions: a theoretical perspective