postgresql -

To query the following data ["aws", "cloud", "ai"] with structure tags jsonb we can use select unnested(tags) as tag from "table_name";