Method _detect_sql_mode

lib/sqlalchemy/dialects/mysql/base.py:3768–3778

(self, connection: Connection)

        return collations

    def _detect_sql_mode(self, connection: Connection) -> None:
        setting = self._fetch_setting(connection, "sql_mode")

        if setting is None:
            util.warn(
                "Could not retrieve SQL_MODE; please ensure the "
                "MySQL user has permissions to SHOW VARIABLES"
            )
            self._sql_mode = ""
        else:
            self._sql_mode = setting or ""

    def _detect_ansiquotes(self, connection: Connection) -> None:
        """Detect and adjust for the ANSI_QUOTES sql mode."""