There there use to be a stronger distinction between Text Editors and IDE’s. Of course there is a wide spectrum from something like ‘nano’ to Microsoft’s Visual Studio (not VScode)
On macOS, BBEdit has had SFTP since the late 1990s. BBEdit is probably closer to the Text Editor than IDE when compared to VSCode
https://www.barebones.com/products/bbedit/
Also on macOS, Panic’s recent Nova editor includes SFTP. Nova is more closely aligned with VScode
https://nova.app
Also be aware that it is possible to use tools like either mount a remote SFTP sever on your local file system. This allows any editor to work on remote files.
On macOS in the Personally these days I mostly code on a Linux KDE system where I use VSCode. On my Macs, I use BBEdit as I have for 25 years.
I do have my eyes on Nova and Zed. Once Zed gets Linux support, I will give it a serious try. 1990’s there was a standard protocol many apps used that allowed your editor to integrated with a stand alone SFTP program. Even though BBEdit had built in SFTP, I would typically use Panic’s Transmit SFTP via this method
Personally these days I mostly code on a Linux KDE system where I use VSCode. On my Macs, I use BBEdit as I have for 25 years.
I do have my eyes on Nova and Zed. Once Zed gets Linux support, I will give it a serious try.