📄 tanstack/db/latest/docs/reference/interfaces/ParseWhereOptions
File: ParseWhereOptions.md | Updated: 11/15/2025
Source: https://tanstack.com/db/latest/docs/reference/interfaces/ParseWhereOptions
Search...
+ K
Auto
Docs Examples GitHub Contributors
Docs Examples GitHub Contributors
Docs Examples GitHub Contributors
Docs Examples Github Contributors
Docs Examples Github Contributors
Docs Examples Github Contributors
Docs Examples Github Contributors
Docs Examples Github Contributors
Maintainers Partners Support Learn StatsBETA Discord Merch Blog GitHub Ethos Brand Guide
Documentation
Framework
React
Version
Latest
Search...
+ K
Menu
Getting Started
Guides
Collections
Frameworks
Community
API Reference
Framework
React
Version
Latest
Menu
Getting Started
Guides
Collections
Frameworks
Community
API Reference
On this page
ParseWhereOptions
Copy Markdown
Interface: ParseWhereOptions<T>
===============================
Defined in: packages/db/src/query/expression-helpers.ts:53
Options for customizing how WHERE expressions are parsed
Type Parameters
---------------
### T
T = any
Properties
----------
### handlers
ts
handlers: object & object;
handlers: object & object;
Defined in: packages/db/src/query/expression-helpers.ts:67
Handler functions for different operators. Each handler receives the parsed field path(s) and value(s) and returns your custom format.
Supported operators from TanStack DB:
- Comparison: eq, gt, gte, lt, lte, in, like, ilike
- Logical: and, or, not
- Null checking: isNull, isUndefined
- String functions: upper, lower, length, concat
- Numeric: add
- Utility: coalesce
- Aggregates: count, avg, sum, min, max
#### Type Declaration ##### add()?
ts
optional add: (...args) => T;
optional add: (...args) => T;
...any[]
T
ts
optional and: (...args) => T;
optional and: (...args) => T;
...any[]
T
ts
optional avg: (...args) => T;
optional avg: (...args) => T;
...any[]
T
ts
optional coalesce: (...args) => T;
optional coalesce: (...args) => T;
...any[]
T
ts
optional concat: (...args) => T;
optional concat: (...args) => T;
...any[]
T
ts
optional count: (...args) => T;
optional count: (...args) => T;
...any[]
T
ts
optional eq: (...args) => T;
optional eq: (...args) => T;
...any[]
T
ts
optional gt: (...args) => T;
optional gt: (...args) => T;
...any[]
T
ts
optional gte: (...args) => T;
optional gte: (...args) => T;
...any[]
T
ts
optional ilike: (...args) => T;
optional ilike: (...args) => T;
...any[]
T
ts
optional in: (...args) => T;
optional in: (...args) => T;
...any[]
T
ts
optional isNull: (...args) => T;
optional isNull: (...args) => T;
...any[]
T
ts
optional isUndefined: (...args) => T;
optional isUndefined: (...args) => T;
...any[]
T
ts
optional length: (...args) => T;
optional length: (...args) => T;
...any[]
T
ts
optional like: (...args) => T;
optional like: (...args) => T;
...any[]
T
ts
optional lower: (...args) => T;
optional lower: (...args) => T;
...any[]
T
ts
optional lt: (...args) => T;
optional lt: (...args) => T;
...any[]
T
ts
optional lte: (...args) => T;
optional lte: (...args) => T;
...any[]
T
ts
optional max: (...args) => T;
optional max: (...args) => T;
...any[]
T
ts
optional min: (...args) => T;
optional min: (...args) => T;
...any[]
T
ts
optional not: (...args) => T;
optional not: (...args) => T;
...any[]
T
ts
optional or: (...args) => T;
optional or: (...args) => T;
...any[]
T
ts
optional sum: (...args) => T;
optional sum: (...args) => T;
...any[]
T
ts
optional upper: (...args) => T;
optional upper: (...args) => T;
...any[]
T
ts
optional onUnknownOperator: (operator, args) => T;
optional onUnknownOperator: (operator, args) => T;
Defined in: packages/db/src/query/expression-helpers.ts:76
Optional handler for when an unknown operator is encountered. If not provided, unknown operators throw an error.
#### Parameters ##### operator
string
any[]
T
