"Contains" filter not working on Postgres jsonb columns (not casted correctly)
1. Database version (Ex: PostgreSQL 10.0): Postgres 10 (actually timescaledb, but this is just a layer on top of postgres)
2. TablePlus version (the number on the welcome or about screen, Ex: build 81): Linux alpha build 54
3. Linux distro (Ex: Ubuntu 18.04): Ubuntu 20.04
4. The steps to reproduce this issue:
If you have a jsonb column (e.g. payload) and use the filters to check if it contains a certain field, it doesn't work. (Error: operator does not exist: jsonb ~~ unknown LINE 1: SELECT * FROM "public"."events" WHERE "payload" LIKE ... HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.)
If I do the same on the Mac client, I indeed get WHERE ("payload"::TEXT LIKE '... in the query, so it is casted to text.
(I hope TablePlus for Linux continues improving; just switched from Mac to Linux and like it)