hugsql 2017-12-27

@udit not sure if i understand the question. If ur db engine supports offset and limit you don’t need anything.

@udit, here’s how I use offset and limit.

select * from table
...
group by col
order by other_col desc
--~ (if (:offset params) "offset :offset")
--~ (if (:limit params) "limit :limit")
It’s probably more idiomatic to use while instead of if since there is only a then block, no else

I think you mean (when ...)