The reason why it happens in the XF upgrade is because we know that this table would prevent the utf8mb4 conversion.
You're right, though, that we need to just catch all exceptions here, or just do the query in the DB adapter, or, arguably, we should be throwing XF\Db\Exception in the SM.