Bridging quantum chemistry and nuclear structure theory: Coupled‐cluster calculations for closed‐ and open‐shell nuclei