Found this thread with the same issue, looks like this might be an AlaSQL issue.
Unfortunate, since it is, well, limiting (
)
For now this looks like it's going to work:
First value is the offset, second is the limit
Edit:
Spoke a little too soon, here it what ended up working in my particular case for pagination:
The two values of the slice method refer to the start and end index of the array to return (more info here). In my example, the first value is the offset, and the limit behavior is achieved by using offset + the number of values you want to return.