I would, and did, when I execute my own queries... But with CDBI, it's all done so many layers lower than my code, that I'm not even sure where the eventual execute happens!
I do believe RaiseError is set though, since the code does die when the error occures.