2 yrs - Translate

Has anyone ever done an IN-DEPTH scriptural study on praying/speaking in tongues?

If so, have you found it to ONLY mean speaking in another ACTUAL foreign language(ie. Greek, french, kswahili, etc) other than your own? Or have you found it to mean speaking a heavenly language that’s NOT an earthly regular language?