The white bars on the abdomen are not normally seen on Sphex species, but common on Turneromyia sp. (genus) (Zebra spider wasp). But is not a Turneromyia sp. either.
Looks like the protective capsule of a Case-bearing Leaf Beetle (subfamily Cryptocephalinae); if so, the hole could be where the emerging adult (or a parasite) emerged.