Of course you can. How do you think developers test their apps?

Never did iOS development. I always assumed it requires active USB connection with a dev machine or an emulator.

Normal people can't. I'd bet more people run jailbroken than bothering with developer-mode sideload.