No. DSiware is built with a specific sdk setting that means it will only work from the sd, DS software will only work from the cart (unless patched).In theory, could slightly modified DS software (official or homebrew) be run from the SD or NAND? [ninja'd]
Patching DS software to work from the SD will most likely never work because the SD is only accessable from the arm7, 99% of cart reads are done from the arm9 so you'd need to ask the arm7 to read the data which would introduce a massive slow down if it worked at all,