code: @WithBridgeMethods(value = MySQLQuery.class, castRequired = true)
      public C cache() {
          return addFlag(Position.AFTER_SELECT, SQL_CACHE);
      }
docs: SQL_CACHE tells MySQL to store the result in the query cache if it is cacheable and the value
  of the query_cache_type system variable is 2 or DEMAND.
  
  @return the current object