How to fix a hole in a PVC pipe - Yep I f**cked up.

cut off the section that the drill went through. Add a compression union joint to connnect the two ends together again.
You may have to break away more of the plasterboard to give yourself better access, and make sure there is enough slack to make the joint after the section is cut off.

if that's the mains water pipe feeding the house no way tape or similar will hold it. When access is such a problem wrapping it in tape would be more difficult that getting a compression fitting onto it.

Presume this pipe is running up to your attic feeding the water storage tanks, is there any slack in the attic you can push down. Wonder is one length of the pipe locates near your mains feed under the kitchen sink and the other in the attic and if there's any possibility of pulling a new length of hydrodare between the two to replace that damaged section?

I used that as an emergency patch on a disconnected hot water cylinder for a couple of days till a replacement could be fitted. Worked ok for the first day, then just slowed the leak. I wouldn’t be relying on it for a vital supply pipe. Especially one under pressure.