code: @WithBridgeMethods(value = MySQLQuery.class, castRequired = true)
      public C bufferResult() {
          return addFlag(Position.AFTER_SELECT, SQL_BUFFER_RESULT);
      }
docs: SQL_BUFFER_RESULT forces the result to be put into a temporary table. This helps MySQL free
  the table locks early and helps in cases where it takes a long time to send the result set
  to the client. This option can be used only for top-level SELECT statements, not for
  subqueries or following UNION.
  
  @return the current object