MEGA-ISP limits?

I was reading that MEGA-ISP is used to burn the bootloader onto a new chip. Can it be used with the IDE to burn an arbitrary sketch onto any arbitrary chip? I'm sure there are limits, but what are they? Are we limited to Arduino-compatible chips? Can the IDE compile for (e.g.) attiny?