Visible light-driven strategies for the synthesis of pyrazole scaffolds: needs, mechanistic insights and sustainable horizons | Synapse