Working with JSON columns in a SQL resource

I've got a SQL database resource that contains a column with JSON objects. I'd like to be able to query and work with those JSON objects a lá Postgres's JSON functions/operators, but I can't figure out how to do so. I've pored over the AlasQL docs, and I'm not sure if I'm missing something -- most of the documentation there seems to be about querying JSON objects using SQL.

1 Like

Hey @theotherben - happy to help! I can confirm that those JSON functions are supported in Retool. Could you clarify the exact functionality you want to achieve? If you have screenshots of your setup so far, that'd be helpful as well!