Alternative to storing JSON array
In my table
trip I currently have a column called destinations which contains an array of objects as a type json. Ideally this should probably be a nested table of some sort (?) so it can be full typed etc. However I'm not sure what the best approach is for setting this up, querying and RLS.