On the Boussinesq system: regularity criteria and singular limits