Add LIMIT and OFFSET support

ufoss-org / kotysa

The idiomatic way to write type-safe SQL in Kotlin

The Unlicense

121 stars 2 forks source link

Closed dave08 closed 3 years ago

dave08 commented 3 years ago

Usually needed for pagination in apis...

pull-vert commented 3 years ago

Thanks for this request, I plan this feature for 0.2.1 release because the next release (0.2.0) is already pretty busy :)

pull-vert commented 3 years ago

@dave08 Kotysa 0.2.1 was release, you can now use LIMIT and OFFSET with Kotysa :)

val paginated = (sqlClient selectFrom USER
        limit 10 offset 12
        ).fetchAll()

dave08 commented 3 years ago

Nice :+1:, thanks!