Due to him being all knowing, he made Adam and Eve such that they both would sin or was negligent in how he designed them. It all comes back to God because of him being all knowing and him being the origin of all things.
The self-limitations would've applied from the onset of human creation. In theory, God could've known the entire stretch of the history of reality itself with perfect clarify and thus would have no real reason to create anything, but he still did. And he did so not knowing the consequences of such because he either chose not to know everything or he doesn't possess omniscience, but considering he told Abraham what'd occur in the next 400 years of his descendants, it's more he's selective about what he allows himself to see (or he's just a phenomenal predictor). The paradox also does not factor the individuality of God, which might irk some Christians since it's personifying him, but still. Why would he bother if he knew everything from the start? Likely because he
chose not to. God's capable of emoting, and if he weren't, nor would humans in theory, since we're meant to be in his image (be it our basic shapes or what we're like and capable of).
Genesis 6:2-8
2 That the sons of God saw the daughters of men that they were fair; and they took them wives of all which they chose.
3 And the Lord said, My spirit shall not always strive with man, for that he also is flesh: yet his days shall be an hundred and twenty years.
4 There were giants in the earth in those days; and also after that, when the sons of God came in unto the daughters of men, and they bare children to them, the same became mighty men which were of old, men of renown.
5 And God saw that the wickedness of man was great in the earth, and that every imagination of the thoughts of his heart was only evil continually.
6 And it repented the Lord that he had made man on the earth, and it grieved him at his heart.
7 And the Lord said, I will destroy man whom I have created from the face of the earth; both man, and beast, and the creeping thing, and the fowls of the air; for it repenteth me that I have made them.
8 But Noah found grace in the eyes of the Lord.
God expresses anger and regret at the wickedness of humanity, planned to destroy everybody, but then Noah effectively saved the world (or humanity & some animals at least) by being an exemplar of good.
Exodus 32:9-14
9 And the Lord said unto Moses, I have seen this people, and, behold, it is a stiffnecked people:
10 Now therefore let me alone, that my wrath may wax hot against them, and that I may consume them: and I will make of thee a great nation.
11 And Moses besought the Lord his God, and said, Lord, why doth thy wrath wax hot against thy people, which thou hast brought forth out of the land of Egypt with great power, and with a mighty hand?
12 Wherefore should the Egyptians speak, and say, For mischief did he bring them out, to slay them in the mountains, and to consume them from the face of the earth? Turn from thy fierce wrath, and repent of this evil against thy people.
13 Remember Abraham, Isaac, and Israel, thy servants, to whom thou swarest by thine own self, and saidst unto them, I will multiply your seed as the stars of heaven, and all this land that I have spoken of will I give unto your seed, and they shall inherit it for ever.
14 And the Lord repented of the evil which he thought to do unto his people.
God was going to force Moses' people into being good, which the verse itself describes as an "evil", and this is another instance of God choosing not to do something he was more than capable of due to being talked out of it.
Hosea 11
11 When Israel was a child, then I loved him, and called my son out of Egypt.
2 As they called them, so they went from them: they sacrificed unto Baalim, and burned incense to graven images.
3 I taught Ephraim also to go, taking them by their arms; but they knew not that I healed them.
4 I drew them with cords of a man, with bands of love: and I was to them as they that take off the yoke on their jaws, and I laid meat unto them.
5 He shall not return into the land of Egypt, and the Assyrian shall be his king, because they refused to return.
6 And the sword shall abide on his cities, and shall consume his branches, and devour them, because of their own counsels.
7 And my people are bent to backsliding from me: though they called them to the most High, none at all would exalt him.
8 How shall I give thee up, Ephraim? how shall I deliver thee, Israel? how shall I make thee as Admah? how shall I set thee as Zeboim? mine heart is turned within me, my repentings are kindled together.
9 I will not execute the fierceness of mine anger, I will not return to destroy Ephraim: for I am God, and not man; the Holy One in the midst of thee: and I will not enter into the city.
10 They shall walk after the Lord: he shall roar like a lion: when he shall roar, then the children shall tremble from the west.
11 They shall tremble as a bird out of Egypt, and as a dove out of the land of Assyria: and I will place them in their houses, saith the Lord.
12 Ephraim compasseth me about with lies, and the house of Israel with deceit: but Judah yet ruleth with God, and is faithful with the saints.
God comes close to destroying Israel (not Judah, these are the tribes) but chooses not to in the end, because he is God and God still loves his children. To me this demonstrates that despite his capability to do much of anything, he makes conscious
choices not to do so. You can put it down to his promise made with Noah to not intervene anymore, or because he still loves humanity in spite of the occasional bout of faithlessness and evil.
Genesis 2:16–17
16 And the Lord God commanded the man, saying, Of every tree of the garden thou mayest freely eat:
17 But of the tree of the knowledge of good and evil, thou shalt not eat of it: for in the day that thou eatest thereof thou shalt surely die.
Genesis 4:6-7
6 And the Lord said unto Cain, Why art thou wroth? and why is thy countenance fallen?
7 If thou doest well, shalt thou not be accepted? and if thou doest not well, sin lieth at the door. And unto thee shall be his desire, and thou shalt rule over him.
Genesis 6:5
5 And God saw that the wickedness of man was great in the earth, and that every imagination of the thoughts of his heart was only evil continually.
From the very start God pretty much hammers home to people that the choice of evil is
yours, and even with warning, people still commit to it and this is God telling them himself. And even though he tells Cain directly that if he does something evil, he'll get fucked, Cain still does it anyway, because that was
his choice to make. You can get into an regressive cycle here of, "why didn't God job him killing Able?" but again, the entire premise is hinged on the idea that God created evil and that man should be deprived of free will to commit that evil, when in reality man created evil and God promised not to interfere with man. It was only when he saw that all of mankind was drawn to committing evil in their hearts and it's all they thought of that he decided to wipe the slate clean, until Noah - because God would rather go back on his decisions than let a
single good person die as the result of his (direct) action.
There isn't too many instances in the Old Testament, but the New Testament and an epistle provides some direct examples of God being able to limit himself:
Mark 13:32
32 But of that day and that hour knoweth no man, no, not the angels which are in heaven, neither the Son, but the Father.
I.E. If Jesus is an incarnation of God, then this incarnation has limited what he knows, which is distinct from the Father who
does know.
Philippians 2:6-8
6 Who, being in the form of God, thought it not robbery to be equal with God:
7 But made himself of no reputation, and took upon him the form of a servant, and was made in the likeness of men:
8 And being found in fashion as a man, he humbled himself, and became obedient unto death, even the death of the cross.
I.E. Jesus voluntarily sets aside divine privileges to enter the human condition fully, even if he hasn't ceased being divine.
TLDR: He chose
not to know. His lack of action thereafter is primarily the result of mercy and being talked out of it by man because, like man, God is capable of emotion. Jesus was self-limiting, meaning God can also self-limit. God also practices restraint when it comes to his wrath, and if he's capable of restraining his power, he's capable of restraining his own access to knowledge too, probably.
Even from my non-religious perspective, even if God does not possess
true omniscience, it still not invalidate his capabilities nor the religion as a whole (the same view I have of the trinity) because ultimately what difference does it honestly make?
Aquinas also proposed another way of looking at it:
“God understands all things, not discursively, but as one whole, eternal act.”
God sees
everything, simultaneously, everywhere all at once. God knows everything with perfect clarity but not disseminate or discriminate with details and particulars, not does he scrutinise things individually, because he sees everything as though it's occurring all at the same time. His limitation therein is choosing not to employ scrutiny
There's also the concept of God's "perfection". A way of looking at his omniscience is less "all knowing" and more "perfect knowledge". His understanding of all things is complete and perfect, that rather than it being a sort of future sight, it's more he's fully able to understand the complexity and capability of all things. I.E. God sees Cain and knows Cain is capable of committing sin, but also knows Cain is capable of not committing sin, ergo he knows both of these things at once without it contradicting omniscience.
There's also, and this might irk some Christians because of it's fanficky nature, possible that the perception of God exact capabilities might be outright wrong since many of his capabilities are ascribed by man rather than outright stated by God himself most of the time. He
does describe in detail his power and omnipresence, but his omniscience is more of in inferred capability of his omnipotence and omnipresence rather than one that's outright stated by him.