The Importance of Marijuana

I've never done marijuana, but I've talked to a lot of people who have. And my understanding is, and then I also had a very dear friend, a die of cancer, could not eat food and had to take THC daily. Not medicinal, but like no, but he got high. So I asked him, he's a traditional Latin Mass Catholic who's taking THC daily prescribed. He's not like going to grateful dead shows. But he is getting high. Where does the church stand on medical use? I think perfectly allowed. If I were dying of cancer right now, God forbid, and I couldn't hold food down and I was losing weight week after week after week