Cannot set LIMIT 0

[ghost]

Describe the bug
Using .Limit(0) clears the limit.

To Reproduce
Any query using .Limit(0).

Expected behavior
.Limit(0) should append LIMIT 0 to the query.

Dialect:

• postgres
• mysql
• sqlite3

Additional context
I know this is kind of a weird use case, but it allows for SELECT 1, 2, 3 FROM dual-style Oracle queries. There also appears to be a ClearLimit() function, so Limit(0) doesn't overlap with it.

[doug-martin]

Hi @im-roryl sorry I havent gotten around to this sooner.

I'm hesitant to change this functionality since it would require a major version change as it is changing existing functionality.

One way we could add this is to create a new LimitZero or ZeroLimit method to allow forcing this as it doesnt make sense in other SQL dialects.