This huge wasp is the sabre wasp an ichneumon wasp, you can read more about them here lhttps://www.buglife.org.uk/bugs-and-habitats/the-sabre-wasp
the long “sting” is actually the ovipositor (egg laying tube) which doubles as a drill to deposit the eggs in larvae that live beep in wood