Global replace for bbcode [code] with backticks

I am unable to insert newlines either using rake posts:remap with the regex replace. No idea if it can even be done.

Q: If I do updates with via the database, do I need to edit both the raw and cooked versions, or if I update the raw will it update the cooked version automagically or do I need to do something to have it update?

I assume the data explorer plugin just does Queries and doesn’t do UPDATEs?