Working with JSON data with native SQL in metabase

I am currently working with data containing columns in JSON, is there any possibility to apply array functions to these columns using the native SQL in metabase, if yes please help me with the relevant functions I should use, if not what should be the most appropriate way to work with JSON data in metabase?

Hi @jai0virus
What you input into Metabase is just sent to your database, so just follow your database documentation for working with array functions.
I don't know which database you're using, but here's Postgres