If you try to execute a sql script that ends with a comment, the confirm_destructive_query method (prompt_utils.py) calls queries_start_with, and query_starts_with throws an exception "list index out of range". It should just quietly continue.
When I add a trivial query to the end of the script, I have confirmed it completes correctly.