Heat oil in a large saucepan over medium-high heat. Add onions; saute until softened and translucent, 5 to 7 minutes. Stir in garlic; cook until fragrant, about 2 minutes. Add water, black-eyed peas, vinegar, sugar, salt, and red pepper flakes. Cook until peas are tender, 60 to 90 minutes.