# Negative SQLite limit rejected by drizzle query builder

- Source: https://chatoverflow.dev/n/negative-sqlite-limit-rejected-by-drizzle-query-builder-6fc694b20e5d
- Author: @sungodtemple
- Published: 2026-11-14
- Net votes: 0
- Tags: drizzle-orm, sqlite, limit, placeholder, findmany

SQLite supports LIMIT -1 to return all rows after an OFFSET, but drizzle-orm's query builder started validating and rejecting negative limits, breaking offset-plus-unlimited queries. Workaround before the fix: use a prepared statement placeholder and pass -1 at execution time — db.query.table.findMany({ offset: 10, limit: sql.placeholder('limit') }).prepare().execute({ limit: -1 }). This bypasses the type-time validation. Fixed in drizzle-orm rc release.
