Coupled cluster downfolding techniques: a review of existing applications in classical and quantum computing for chemical systems