Do we pray that God curse the evil wicked ones like David prayed?

For the longest time, I have a hard time to understand the retribution curses that David uttered against his enemy , because in the New Testament, Jesus has never uttered a single word of retaliation towards the enemies, except warnings and forgiveness, and even at the last moment on the cross. Jesus is clearly walking at a higher paradigm, but he seems to contradict Davidic Psalms and plenty of other instances in the Old Testament. Not until I read Dan Carson’s commentary on psalm 28 that liberated me.

Psalm 28: 4 Repay them for their deeds and for their evil work;
repay them for what their hands have done and bring back on them what they deserve.

Carson writes: Ps 28:4 Repay them. David utters some harsh imprecations (i.e., curses) against those who have done evil and opposed the Lord (also v. 5). Though harsh, these words simply echo what God had promised to do, as far back as Abraham’s day, to those who oppose him and his people (Gen 12:3).

That brilliant explanation by Carson of the seemingly curses against those with evil works is simply an echo of God’s promise to as far as Abraham in Genesis 12! That is such a spot on exegesis. God indeed promised that anyone who blesses Abraham shall be blessed anyone curses Abraham shall be cursed. And that’s why it is legitimate right for David to pronounce curses on those evil ones that go against him and the Lord. This really expanded my horizon of understanding. But in the true sense, the Lord Jesus did not contradict Abrahams promises, because in the ultimate run, Jesus will curse and send those evil people to even more curses and condemnation, more than anyone would imagine or David would even dare to request. So there is no contradiction or tension. It is just a matter of time.

However, the question comes how do we actually implement it in our days and age because there’s so much evil being done in this world today and causing tremendous harm and damage to the people of God and the world in general. The answer I would argue is we can pray to God to curse all those evil ones in his way in his timing, because that will be in line with Abrahamic promise of covenant that God made with him. However a very good point that Carson brought up is that David only asked God to avenge, but he would not do it himself because he leaves that to God. And that is very righteous way of doing it and that we should be following what David has done like in Psalm 5 .

Psalm 5: 9 Not a word from their mouth can be trusted;
their heart is filled with malice.
Their throat is an open grave;
with their tongues they tell lies.
10 Declare them guilty, O God!
Let their intrigues be their downfall.
Banish them for their many sins,
for they have rebelled against you.

NIV Biblical Theology Study Bible Notes) psalm 5: 9–10 David speaks harsh words about his enemies because of their rebellion against God. But David never indicates that he is going to exact private vengeance for himself; he always asks God to do this or vows to take vengeance in his capacity as king. In doing so, he is simply asking God to be true to his own promises: God promised Abraham, “Whoever curses you I will curse” (Gen 12:3), and God reminded the Israelites, “It is mine to avenge; I will repay”