FYI, there is an alternative, depending on what you need it for: https://jamiekoufman.com/tne-transnasal-esophagoscopy-is-the...
However, doctors who do it are a bit hard to come by.
With a esophagogastroduodenoscopy, I think the main issue is the gag reflex, not necessarily the pain.