could it make sense?

yes, like an array column, but there are some differences from an array column.

ok

So if your query was give me all companies that have location = USA. This will match the row in my example, even though there are more than one locations.

it someting like tableA(companies) and tableB(locations) and then join tableA and tableB talking about rdbms