Joining SQL tables on a JSON array

How to join PostgreSQL tables on a JSON array of ids. Joining tables is a common SQL operation that allows you to combine data from two or more tables into a single result set. Normally, join operations are performed on columns that have matching val...