The blog specifically says that they're getting the SQL AST so presumably they would not execute something like a DELETE.

Correct. We only enable fast previews for SELECT statements, which is the actual hard problem. This said, at some point we're likely to also add support for previewing a CTAS before you actually run it.

Cool. Now, there's this thing called a joke...