Adding LIMIT to Query builder

[miry]

I couldn't find a straightforward way to add a LIMIT to a query, so I came up with this simple solution:

diff --git a/src/marten/db/query/set.cr b/src/marten/db/query/set.cr
index 0de0fb56..9f730101 100644
--- a/src/marten/db/query/set.cr
+++ b/src/marten/db/query/set.cr
@@ -1152,6 +1152,20 @@ module Marten
           qs
         end
 
+        # Limits the number of records returned in the query result.
+        #
+        # ```
+        # query_set = Post.all
+        # query_set.limit(100)
+        # ```
+        #
+        # In the above example, at most 100 records will be returned.
+        def limit(number : Int)
+          qs = clone
+          qs.query.slice(0, number)
+          qs
+        end

I feel like this is a fundamental feature that shouldn’t be missing,
but I’m wondering if there’s an existing alternative I might have overlooked.

My goal is to generate SQL like this:

SELECT * FROM posts LIMIT 100

Would appreciate any feedback or suggestions! 🚀

[ellmetha]

Hey! 👋

Defining query set limits is something that is supported by the framework with the #[] method. For example:

Post.all[...100] # Returns the first 100 Post records