[feature] Add allowMultiQueries Option to MySqlConnectionConfiguration

[tjdskaqks]

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

It is currently not possible to use the allowMultiQueries option in MySqlConnectionConfiguration.

Describe the solution you'd like
Please add an option to specify allowMultiQueries in ConnectionFactoryOptions or MySqlConnectionConfiguration.

Additional context
Add any other context or screenshots about the feature request here.

Code Example:

            val connectionFactory =
                MySqlConnectionFactory.from(
                    MySqlConnectionConfiguration.builder()
                        .host(url)
                        .username(username)
                        .password(password)
                        .database(dbname)
                        .sslMode(SslMode.DISABLED)
                        .port(port)
                        .allowMultiQueries(false) // <-
                        .build(),
                )

[jchrys]

Even now, multi queries are supported when using client-side prepared queries(default).
Do you perhaps not want to allow multi queries? Could you please explain your use case in more detail?

[tjdskaqks]

Yes, because I don't want to allow multiple queries. I want to prevent SQL injection vulnerabilities, so it would be nice to have an option.

[jchrys]

You're safe from SQL injection when you write static SQL and bind parameters using Statement#bind. However, in case you find any vulnerabilities, please report them via security.
That said, you make a valid point—utilizing the allowMultiQueries flag can help reduce the attack surface.
Thanks!

[tjdskaqks]

Thank you.