Quantum simulation with bosonic atoms in optical lattices under the microscope