Help with query via the client API

I'm trying to convert this PostgreSQL query to PostgREST or the client API, but cannot find any good resources on nested WHERE constraints for example.

SELECT *
FROM records AS r
JOIN cells AS c ON r.id = c."recordId"
WHERE 
      (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%Ams%')
  AND (c."columnId" = '6c037d08-2e4f-489b-ba1a-89b60007954b' AND c."data"->'value'->'result'->>'city' LIKE '%TH%')
;


I want the above to be converted to client API.
Was this page helpful?