Pagination Offset in Query JSON with SQL

Hey folks! This is actually a known bug, and I've bumped it with the dev team, thanks for bringing it up here!

In the meantime can you try adding the following as a query transformer?

return data.slice({{offset.value}}, {{offset.value + limit.value}})