Enlighten Undead

You touch an undead creature. Its Intelligence score increases by 1d8 + your spellcasting ability modifier. It regains any features, abilities, feats, traits, and proficiencies it had in life. It understands and can speak the languages it knew in life and learns one that you know. As well, its alignment changes either to what it was in life or to be the same as yours, your choice.

You can allow it to regain its memories, personality, and soul or give it a personality of your choice. In any case, it becomes sentient, in effect a reborn or dhampir (or other undead races) NPC wise

If you uses that on a corpse it will become an reanimated undead if it has the needed parts to do so (all its limbs and head) if not it shall be an spirit or another type of undead depending on the limbs.

If the god or goddess feels pity they will give a replacement for the missing parts provided the caster gives tribute (a gem of 100gp or higher, depending on the dm/gm at the time)

For 7 days they will be friendly  to you and your allies until harmed or the days ends, depending on how they are treated they will either be friendly or something drastic.

if the caster wants to boost the range of the spell they would have to use a spell slot per the range (1st=5 2nd=10 3rd =15 4th=20 5th=25).The Caster can only use one spell slot per casting

Warning this does not work on Completely destroyed corpses ( burned corpses may work but not if they are only ashes or disintegrated with disintegration) you will need a wish spell or another spell if this is the outcome