Depends on Training
Like any medical/dental procedure, if the person performing it is licensed, conscientious, and up-to-date, then it will be safe.
Most sates have very stringent guidelines and licensing requirements for dentists who offer sedation, so you can have a high degree of confidence and feel safe. Oral surgeons, in particular, are highly trained in sedation. Some dentists also work with anesthesiologists.