Let me be one of the first to welcome you to the forums!
Interestingly, Thomas Aquinas (perhaps Augustine too?) points out that the midwives were rewarded solely for their faith, and not their lie.
The midwives were rewarded, not for their lie, but for their fear of God, and for their good-will, which latter led them to tell a lie. Hence it is expressly stated (Exodus 2:21): “And because the midwives feared God, He built them houses.” But the subsequent lie was not meritorious.
As for Rahab, I’ve seen a similar argument, that her reward was not due to her lie, but rather her good-will towards God. . . in other words God was approving a liar’s faith, but not the fact that she was a liar. Similarly, the argument continues, neither did God approve of her harlotry but her faith.
The point, I think, is that in those two events we have something else operative that God may be blessing. I’m not sure we can look to these events to say that God condones lying.
Just my opinion!