I have tried JB Weld products, epoxy, water epoxy, and water tape. I do not want to replace the pipe--just fix it for now. The pipe is a cold water supply.
This question comes up in the first page on Google and there's no mention of a Sharkbite, so I thought I would necro-answer. Sharkbites are compression fittings available at Home Depot. They function similar to a repair clamp, but they seem like they seal better to me. They're very easy to install, as well.
Pipe Repair Clamp
There are quite a few different styles; however, almost all of them are designed for metal pipes. Personally, with PVC I still suggest replace a section of the pipe, but if you can't this will get by in a pinch.
Make sure to prepare the surface. Turn the water supply off, sand the area (get rid of your epoxies and rough up the surface). For a good seal, I'd add some 100% silicone "caulking". then put the clamp on. The clamps come with a rubber gasket and if you are using a universal size one then be extra careful not to crack the pipe, it takes a bit but is surprisingly easy when using tools. Allow a couple of hours for the silicone to dry (most dry times listed are expecting surface air to help dry/cure it so if you can manage it leave it overnight)
I had a puncture happen in an area that cutting the pipe and adding a coupling was going to be a super mission. What I ended up doing was cutting a coupling in half (so you get 2 u shaped pieces), gluing it on, and using a hose clamp to tighten it. This was for a sprinkler pipe so not nearly as much constant pressure as a house pipe but it's been holding for weeks now.
Sombody went through a wall in my rv with a finishing with a finishing nail. The pipe it punctured was a 1" long 1/2" pipe, In such a tight spot I couldn't use a saw, almost got a small cut off wheel, but instead used a ratcheting pvc cutter (looks like scissors or pruners, $12 at home depot) cut the pipe near the hole. Used Oatey brand "handy pack" which contains purple primer and medium orange cpvc cement, and used it to "weld" on a $.73 coupler fitting. This will be a permanent fix. Also I installed this on a water line for the inside/outside showers, toilet, and bathroom sink. Not drinking water so I didn't even ask if it was drinking water safe! I'm sure it would be fine after thoroughly running water or if you have a high grade water filter.