That glamorous insect is a squash vine borer. It is a native insect so it does have a right to bore squash vines with which it co-evolved on this continent. It clearly plays a role as a pollinator too. However, you might want to use a veil like Remay on your squash plants during its active stage because they can do a real number on those vines.