Red oak clearwing borers do, indeed, have partially clear wings. This one is a paper wasp mimic.

Photo by Carroll E. Younce, USDA Agricultural Research Service, bugwood.org