drizzle-orm icon indicating copy to clipboard operation
drizzle-orm copied to clipboard

feat: add support for "limit 0"

Open sillvva opened this issue 9 months ago • 0 comments

Fixes #2011

MySQL, PostgreSQL, and SQLite all support LIMIT 0 as a way to quickly return an empty dataset. Negative numbers are not supported.

It can be useful for testing queries, but in Drizzle's case, it can also be a simpler way to get conditional nested data without messing up the Typescript return type as demonstrated in #2011

The changes proposed ensure placeholders (object) and numbers >= 0 are still supported. If a developer tries to use a negative number, it would exclude the limit rather than throw an error.

sillvva avatar May 04 '24 14:05 sillvva