content
content copied to clipboard
`SQLOperator` type doesn't include `<=` (less than or equal) or `>=` (greater than or equal)
Environment
- Operating System: Windows_NT
- Node Version: v22.12.0
- Nuxt Version: 3.17.5
- CLI Version: 3.25.1
- Nitro Version: 2.11.12
- Package Manager: [email protected]
- Builder: -
- User Config: compatibilityDate, devtools, modules
- Runtime Modules: @nuxt/[email protected], @nuxt/[email protected], @nuxt/[email protected], @nuxt/[email protected]
- Build Modules: -
Version
v3
Reproduction
N/A
Description
The SQLOperator type definition allows the following operators: '=' | '>' | '<' | '<>' | 'IN' | 'BETWEEN' | 'NOT BETWEEN' | 'IS NULL' | 'IS NOT NULL' | 'LIKE' | 'NOT LIKE'
<= and >= are missing from this list but they're supported in SQLite and widely used. They seem to work fine (tested in a queryCollection().where() call), they just cause a type checking error:
Additional context
No response
Logs