Joshen Lim b1a9e072ec Update table editor ilike related comparators to implicitly wrap filter string with % if not provided (#50394) ...

### Context

For table editor - the `ilike` related comparators expect users to input
a `%` in the filter string, which for non-developers might not be
intuitive.

Hence opting to implicitly wrap the filter string with `%` in the query
when filtering if non provided
<img width="1182" height="755" alt="image"
src="https://github.com/user-attachments/assets/819c39f5-fcbf-4213-95b3-3ad1ee901f47"
/>


<!-- This is an auto-generated comment: release notes by coderabbit.ai
-->

## Summary by CodeRabbit

* **Bug Fixes**
* Improved pattern-match filters so bare text values perform contains
matching by automatically wrapping them with wildcards.
* Preserved explicit wildcard patterns using `%` or `_` without adding
additional wildcards.
* Improved handling of empty values for non-text filters while retaining
existing numeric filter validation.

<!-- end of auto-generated comment: release notes by coderabbit.ai -->

2026-09-16 14:32:19 +08:00

..

get-cell-value-mutation.ts

Consolidate execute-sql-query into execute-sql-mutation (#46944)

2026-06-16 00:07:16 +08:00

keys.ts

…

operation-queue-save-mutation.test.ts

fix(studio): batched table edits issues (#47319)

2026-06-29 08:12:18 -06:00

operation-queue-save-mutation.ts

fix(studio): batched table edits issues (#47319)

2026-06-29 08:12:18 -06:00

table-row-create-mutation.ts

Consolidate execute-sql-query into execute-sql-mutation (#46944)

2026-06-16 00:07:16 +08:00

table-row-delete-all-mutation.ts

Consolidate execute-sql-query into execute-sql-mutation (#46944)

2026-06-16 00:07:16 +08:00

table-row-delete-mutation.tsx

chore: refactor Button API so that it can be used a standard button (#46880)

2026-06-16 23:59:58 +02:00

table-row-truncate-mutation.ts

Consolidate execute-sql-query into execute-sql-mutation (#46944)

2026-06-16 00:07:16 +08:00

table-row-update-mutation.ts

Consolidate execute-sql-query into execute-sql-mutation (#46944)

2026-06-16 00:07:16 +08:00

table-rows-count-query.ts

fix(pg-meta): scope remaining O(catalog) introspection queries behind pgMetaScopedIntrospection (#48148)

2026-07-24 08:07:08 +02:00

table-rows-query.test.ts

cleanup: fix import order and prefixes for studio/data (#44501)

2026-04-03 09:15:57 +02:00

table-rows-query.ts

fix(studio): scope table editor introspection CTEs to target table OID (#47894)

2026-07-14 13:16:11 +02:00

utils.test.ts

Update table editor ilike related comparators to implicitly wrap filter string with % if not provided (#50394)

2026-09-16 14:32:19 +08:00

utils.ts

Update table editor ilike related comparators to implicitly wrap filter string with % if not provided (#50394)

2026-09-16 14:32:19 +08:00