We study the conditions under which, using a canonical transformation, the phases sought after for the repulsive Hubbard model, namely, a Mott insulator in the paramagnetic and antiferromagnetic phases, and a putative d-wave superfluid can be deduced from observations in an optical lattice loaded with a spin-imbalanced ultracold Fermi gas with attractive interactions, thus realizing the attractive Hubbard model. We argue that the Mott insulator and antiferromagnetic phase of the repulsive Hubbard model are easier to observe in the attractive Hubbard mode as a band insulator of Cooper pairs and superfluid phase, respectively. The putative d-wave superfluid phase of the repulsive Hubbard model doped away from half filling is related to a d-wave antiferromagnetic phase for the attractive Hubbard model. We discuss the advantages of this approach to “quantum simulate” the Hubbard model in an optical lattice over the simulation of the doped Hubbard model in the repulsive regime. We also point out a number of technical difficulties of the proposed approach and, in some cases, suggest possible solutions.