I have a postgres database table where one of the many columns is defined as
supported_currencies JSON NOT NULL DEFAULT '["USD"]'::JSON
In the plain SQL I am able to query this table as below
<code>select * from <db_table> where supported_currencies::text in ('["USD"]', '["AUD"]', '["EUR"]')
</code>
<code>select * from <db_table> where supported_currencies::text in ('["USD"]', '["AUD"]', '["EUR"]')
</code>
select * from <db_table> where supported_currencies::text in ('["USD"]', '["AUD"]', '["EUR"]')
I am trying to implement this using jooq’s feature, I have been exploring and trying a few things have not helped so far.