Yes. I'm generally anti-med (try everything else...) except for vaccines and antibiotics. I do worry about side effects. But our experience with DDAVP was totally positive and absolutely the best thing we ever did. Our son took it until age 12. He stopped once, it didn't work out (bed-wetting returned after about 3 months after it wore off), and he went right back on it. Not one side effect. We never, ever questioned our decision.
We had already restricted fluids, and had already done the "wake him up to pee" routine. We did the alarms, which we realize were pointless because they only go off after the underwear is already wet. We talked to the pediatrician and a pediatric urologist who told us he had some kids up to age 18 taking the medication for years until their bodies developed. We learned how common this problem is, and that it's not about "training" or "deep sleeping."
He needed to sleep through the night for brain development. That was the biggest motivator. We knew that not sleeping was horrible for him long term. We didn't know if he'd have a medication problem - so we chose the goal we know he needed to have. He needed a social life. He needed to go to overnight camp. He needed to go to, and host, sleep overs.
We sent him to camp with a prescription - that was easy, with so many kids on so many meds. We sent him to sleepovers with friends with 1 pill in a blank pill bottle from the pharmacist - his name only, not even the name of the prescription. We told the other parents he needed to take "an allergy pill" before bed. No questions, no info that could "slip" to another kid, no problems.
Your child is 10. He's had 10 years of not being dry. Please give him this gift. Message me if you want to chat further.