Is it possible to do a hole through the middle of the joist, and
thread the pipe through it?

If you do so, and it is the correct way to proceed, then use plastic
pipework (unless gas!), as it is far easier to thread through than rigid
metal and doesn't require accurate hole positioning, or multiple joins.

Christian.