code: @WithBridgeMethods(value = MySQLQuery.class, castRequired = true)
      public C lockInShareMode() {
          return addFlag(Position.END, LOCK_IN_SHARE_MODE);
      }
docs: Using LOCK IN SHARE MODE sets a shared lock that permits other transactions to read the examined
  rows but not to update or delete them.
  
  @return the current object