code: @WithBridgeMethods(value = MySQLQuery.class, castRequired = true)
      public C straightJoin() {
          return addFlag(Position.AFTER_SELECT, STRAIGHT_JOIN);
      }
docs: STRAIGHT_JOIN forces the optimizer to join the tables in the order in which they are listed
  in the FROM clause. You can use this to speed up a query if the optimizer joins the tables
  in nonoptimal order. STRAIGHT_JOIN also can be used in the table_references list.
  
  @return the current object