[Feature Request] Providing option for ignore mysql special comment.

[okhowang]

I use go-mysql-server for sql testing and unittest.
there is some sql feature supported by mysql, but not supported by go-mysql-server.
usually, mysql dialect can be wrapper by /*! */ comment which will be ignore by other sql engine, but executed by mysql.
for example

create table a (id bigint) /*! engine=innodb */

go-mysql-server will execute statement in the special comment too.

but not all mysql syntax can be supported by go-mysql-server.
adding/removing partition is the problem to me currently. dolthub/dolt#8744

maybe go-mysql-server can provide a option to DO NOT execute mysql-only code, for keep basic sql work.
as a workaround for the feature not supported by go-mysql-server currently.