The Bethe–Salpeter equation in chemistry: relations with TD-DFT, applications and challenges | Synapse