What is the ruling on performing the standing (qiyām) and bowing (rukū‘) portions of the prayer normally, while performing the prostration (sujūd) seated due to knee pain?
All praise is due to Allah, and peace and blessings be upon our master, the Messenger of Allah ﷺ.
If performing sujūd (prostration) in prayer causes the worshipper pain in the knees, then it is permissible for him to perform it through gesture (īmā') while seated, since Allah, Glorified and Exalted is He, has lifted hardship from His servants. On the authority of ‘Imrān ibn Ḥuṣayn (raḍiyallāhu ‘anh), he said: "I suffered from hemorrhoids, so I asked the Prophet ﷺ about [how to perform] the prayer, and he said: 'Pray standing; if you are unable, then sitting; and if you are unable, then on your side.'" [Ṣaḥīḥ al-Bukhārī]
If the valid excuse later subsides, the worshipper is then obligated to perform the prayer with all its pillars and conditions fully observed — including standing, rukū‘ (bowing), and sujūd (prostration). And Allah, the Exalted, knows best.
Which is better in night prayer: long standing (Qiyam) or long prostration (Sujood)?
Long standing (Qiyam) is better in prayer. However, a Muslim should also observe tranquility and composure in their prayer.
What is the ruling on taking a medication tablet sublingually during the daytime in Ramadan?
All praise is due to Allah, and peace and blessings be upon our master, the Messenger of Allah ﷺ.
Taking a medication tablet sublingually (under the tongue) during the daytime in Ramadan does not invalidate the fast, since it does not reach the internal cavity (al-jawf) through an open passage.
However, if the tablet dissolves and any part of it is swallowed, then the fast is broken.
And Allah, the Exalted, knows best.
Is it permissible to offer prayer at home, or should it be offered in the mosque?
All perfect praise be to Allah, The Lord of The Worlds. It isn`t preferable for the man to pray at home as praying in the mosque is twenty seven times more rewarding. Therefore, this should motivate him to offer prayers in the mosque. And Allah Knows Best.