Well after e8 it seems the hologram is out, but Sinestro implies he can resurrect actual Hal with John and the new lantern.

I hope that happens in S2, Kyle Chandler is great so far. He’s determined, he cares, and yet he’s often aloof, even callous (leaving John to burn to death). I think the show would really struggle without him in it.