Was John the Baptist in the Church?

For I say unto you, Among those that are born of women there is not a greater prophet than John the Baptist: but he that is least in the kingdom of God is greater than he. Luke 7:28

I have seen this statement diagrammed and done so myself. If he that is least in the kingdom of God is greater than John, then John is not in the kingdom. Sounds shocking to many, but it should not. John was born of woman, Christians are born of God.

Who hath delivered us from the power of darkness, and hath translated us into the kingdom of his dear Son: Colossians 1:13

So we were translated. That's how we made it. It seems so positional. I certainly do not feel greater than John the Baptist, but Luke says even the least in the kingdom is greater than he. This is the doing of God, beyond understanding, but true none the less.

While we thank God for our material blessings, should we not thank Him for the wonderful position we will be in, in the world to come, however lowly our situations are now?