Specify particular column to be searched.

[JakNowy]

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

[onejgordon]

Looks related to #459. We'd find this extremely useful as well.