Is it possible to make this query typesafe?

I needed one more data from the same table. I decided to go with self join following the aliased table method. But it the type for result is never. Maybe it's because of custom query, i m using. The result is as expected but the problem is the type of result. Is there a way I can make it more type safe?