Theory and simulation of strong correlations in quantum Coulomb systems