Open $sd$-shell nuclei from first principles