The Spallation Neutron Source (SNS) at Oak Ridge National Laboratory provides an intense, high-quality source of neutrinos from pion decay at rest. This source was recently used for the first measurements of coherent elastic neutrino-nucleus scattering (CEvNS) by the COHERENT collaboration, resulting in new constraints of beyond-thestandard-model physics. The SNS neutrino source will enable further CEvNS measurements, exploration of inelastic neutrino-nucleus interactions of particular relevance for understanding of supernova neutrinos, and searches for accelerator-produced sub-GeV dark matter. Taking advantage of this unique facility, COHERENT's suite of detectors in "Neutrino Alley" at the SNS is accumulating more data to address a broad physics program at the intersection of particle physics, nuclear physics, and astrophysics. This review describes COHERENT's first two CEvNS measurements, their interpretation, and the potential of a future physics program at the SNS.