I have found people claiming that gods do not procreate like humans but procreate without any bodily union on Quora, does this idea have scriptural backing?
The notion that Gods cannot procreate through their respective wives, might have emanated from the episode from Bala Kanda of Ramayana, wherein Uma, the consort of Shiva, curses so.
यस्मान्निवारिता चाहं संगता पुत्रकाम्यया || १-३६-२१ अपत्यं स्वेषु दारेषु नोत्पादयितुमर्हथ |
" 'Wherefore, I who am desirous of a son had been prevented from the intimacy with my husband, therefore you shall be infecund to beget progeny through your own wives. "
अद्य प्रभृति युष्माकमप्रजाः सन्तु पत्नयः || १-३६-२२ एवमुक्त्वा सुरान्सर्वान् शशाप पृथिवीमपि |
" 'And from now onwards you wives shall remain infertile...' and on saying this way to all of the gods she also gave a curse to the earth."
We have to remember the following issues:
1) Much before Ramayana was composed, Rig Veda contained verses indicating Maruts as the sons of Rudra and Pṛśni.
They who are Sons of the rain-pouring Rudra, whom the long-lasting One had power to foster: The Mighty Ones whose germ great Mother Pṛśni is known to have received for man's advantage.
So the story of Uma cursing Gods might be an interpolated story.
2) The God is only ONE and formless. Most of stories that were described in Literature about children of God are epithets only, but should not be taken literally.