[Improvement] Add a Limit() Method to Only Return X Number of Results

[homestar9]

It would be helpful to be able to limit the number of results in queries. Currently it's easy to get the first() record, paginate(), and get() all records.

I could see limit() working like this:

// get the first 5 rows from the product table
qb.get( "product" ).limit( 5 ).get();

[elpete]

https://qb.ortusbooks.com/query-builder/building-queries/limit-offset-and-pagination

[homestar9]

Brainfart! Sorry Eric!