It would be possible, since php and mysql do support transactional SQL. (Note: You must use InnoDB type tables or Transactions, will not work.)
I haven't done much research as to what would need to be updated and it isn't a really common request, so I wouldn't expect it to be on the top of our priority list at this point.
Also transactional sql would have a lot to do with positioning of code, and this is something Dreamweaver is notoriously bad at. This might make an extension integration more difficult. Unless we have a lot more requests for it, it is unlikely to show up in the next version.