Bottom line is, for as long as so called “malware” is inside archive, it cannot do any harm. When you execute it inside archive, it has to first get extracted to disk. At which point, ANY antivirus will detect it. This isn’t an excuse of any kind, it’s just how things work. And scanning archives on-access/real-time on desktop systems is a total waste of time, it’s why no one is doing it.

Like I’ve said, only time direct archive scanning matters at all are mail server scanning, because you want to catch as much as possible during transmission through the server without the need to actually unpack and run archive contents.