Colloquium_20231031_Emergent phenomena in constrained quantum many-body systems