Checklist
- There are no similar issues or pull requests for this yet.
Is your feature related to a problem? Please describe.
I can specify columns to search against, using column_sortable_list. But afaik, it always searches in all columns, which is often unnecessary costly.
Describe the solution you would like.
I would like to be able to pass search terms as keywords eg. "field1 = 'abc'", so that it's the only filter executed on the database level, rather than "field1 = 'abc', field2 = 'abc'".
Describe alternatives you considered
Even better, the filters could be able to differentiate column type and pick more optimal operator than ilike for columns like int or primary key and leverage their indicies. Maybe even between operators for numbers and timestamps?
Additional context
No response
How does funding with Polar work?
Pay now to fund the work behind this issue.
Get updates on progress being made.
Maintainer is rewarded once the issue is completed.
Backer
You're funding impactful open source efforts
Contributor
You want to contribute to this effort
Maintainer
You want to get funding like this too