When using ANSI_QUOTES it's impossible to execute a migration that has comments on columns, because they are wrapped with double quotes, not with single quotes.

I made local changes on Illuminate\Database\Schema\Grammars\MySqlGrammar just to test my hipotesis, my tests with single quotes in comments worked with and without ANSI_QUOTES, so comments can be wrapped with single quotes.

The code from MySqlGrammar.php:

return ' comment "'.$column->comment.'"';

Became:

return " comment '".$column->comment."'";

I'll make a pull request soon if confirmed.