Is raffinose broken down into its component sugars when cooked?
For a few years between around 2004 and 2007, a number of Korean and Japanese companies started started emphasizing products sweetened with various industrially isolated oligosaccharides, which is the family of sugars that raffinose belongs to. I believe the sources commonly extracted from included soybeans and other beans, based on the information from Chinese, Korean and Japanese manufacturers I was in contact with at the time. I even ran into one Korean beverage producer that went so far as to switch from sucrose to oligosaccharides in all of their products, although I recently spotted their products at Trader Joe's and that made me realize they've since either liberalized or backtracked on that decision.

http://www.foodnavigator.com/Science-Nutrition/Novel-oligosaccharides-as-sweeteners-for-food-beverages (which has a couple of annoying interstitial and/or intrusive ads; I don't have any influence over their content, but my apologies nonetheless) seems to indicate that certain new commercially produced oligosaccharides are stable in a fairly narrow temperature and PH range, so I suspect the answer to your question is "it depends." Raffinose is apparently still a frequent subject of study, though it seems like the question you have should be reasonably well answered by now; I'm not a chemist, so I can't parse much from the research summaries I'm able to locate. But I suspect that whatever happened, the isolate oligosaccharide products turned out not to be a panacea, or at least the marketing story turned out to be inadequate to sufficiently drive sales.

http://www.jafra.gr.jp/eng/origo.html indicates that raffinose can be extracted from (some form of) beets for use as a sweetener.

In any event, there's a chance you may be able to find oligosaccharide syrup or maybe even a crystalline form if you look hard enough, and it appears, from what little I'm able to glean, that it's fairly stable, and probably not going to break down in cooking. But I suspect that, like most sugar substitutes, simply replacing your sugar consumption with an alternative sweetener won't bring about meaningful health benefits; nearly every "healthy" sweetener has some undesirable side effects when consumed in large quantities.

Personally, I have a strong bias against any attempt to treat food as some sort of medicine, and my experience is that food manufacturers have little interest in making you healthier (but they do have interest in profiting based on your motivation to be healthy), so I wouldn't put too much stock in the idea that oligosaccharides, or anything else, are a meaningfully healthier alternative to sucrose. There are probably better ways to improve your health than by relying on food technology, and consuming moderate amounts of sweeteners of any type is probably more beneficial than replacing heavy consumption of sucrose with heavy consumption of the alternative sweetener of the month. But there certainly have been efforts to commercialize oligosaccharides for the health food market, and it's probable that there's at least some data to support the notion that oligosaccharides have some health benefits of some kind.