code: public <E extends Model>  LazyList<E> limit(long limit){
          if(fullQuery != null && !forPaginator) throw new IllegalArgumentException("Cannot use .limit() if using free form SQL");
  
          if(limit < 0) throw new IllegalArgumentException("limit cannot be negative");
  
          this.limit = limit;
          return (LazyList<E>) this;
      }
docs: This method limits the number of results in the resultset.
  It can be used in combination with the offset like this:
  
  <code>List&lt;Event&gt; events =  Event.find("mnemonic = ?", "GLUC").offset(101).limit(20).orderBy("history_event_id");</code>
  This will produce 20 records, starting from record 101. This is an efficient method, it will only retrieve records
  that are necessary.
  
  @param limit how many records to retrieve.
  @return instance of this <code>LazyList</code>