Zechariah 12 was already fulfilled.
John 19
36For these things were done, that the scripture should be fulfilled, A bone of him shall not be broken.
37And again another scripture saith, They shall look on him whom they pierced.
Yes and no. Yes, Jesus was pierced. No, God has not destroyed the nations that come against Israel and poured out a spirit of supplication on them.
I am indeedglad to discover that we share (I think) views regarding Israel/the Church. I believe the TRUE Israel is one and the same as the Church, whereas the flesh Israel is just the nation of blood descendants, and not all of them belong to the TRUE Israel, which is the Church.
Now maybe we should discuss the 'remnant'. It seems that is the next stepping stone to understanding your theological view.
Yes the church (which is comprised of PART of Israel and PART of gentiles) is different, separated from earthly Israel. A remnant of earthly Israel are preserved for a millennial role.
8Behold, the eyes of the Lord GOD are upon the sinful kingdom, and I will destroy it from off the face of the earth;
saving that I will not utterly destroy the house of Jacob, saith the LORD.
9For,
lo, I will command, and I will sift the house of Israel among all nations, like as corn is sifted in a sieve, yet shall not the least grain fall upon the earth.
10All the sinners of my people shall die by the sword, which say, The evil shall not overtake nor prevent us.
11In that day will I raise up the tabernacle of David that is fallen, and close up the breaches thereof; and I will raise up his ruins, and I will build it as in the days of old:
12That they may possess the remnant of Edom, and of all the heathen, which are called by my name, saith the LORD that doeth this.
Verse 13 describes the harvest of the church as Israel is planted.
13Behold, the days come, saith the LORD, that the plowman shall overtake the reaper, and the treader of grapes him that soweth seed; and the mountains shall drop sweet wine, and all the hills shall melt.
14And
I will bring again the captivity of my people of Israel, and they shall build the waste cities, and inhabit them; and they shall plant vineyards, and drink the wine thereof; they shall also make gardens, and eat the fruit of them.
15And
I will plant them upon their land, and they shall no more be pulled up out of their land which I have given them, saith the LORD thy God.
Amos 7
1Thus hath the Lord GOD shewed unto me; and, behold, he formed grasshoppers in the beginning of the shooting up of the latter growth; and, lo, it was the latter growth after the king's mowings.
NIV makes more sense. Also shows the church removed when the remnant of Israel "sprouts".
1 This is what the Sovereign LORD showed me: He was preparing swarms of locusts (gog armies) after the kings share had been harvested (church) and just as the late crops were coming up (Israel) .