When Will COVID End?

Coming up on two years of the Coronavirus pandemic, how much longer will it last? Is it like the Spanish flu or will it never go away?