Well, that depends on how you manage it. An ORM will find it trivial. Custom SQL, not always so much. That said, PostgreSQL offers https://www.postgresql.org/d

Well, that depends on how you manage it. An ORM will find it trivial. Custom SQL, not always so much. That said, PostgreSQL offers https://www.postgresql.org/docs/current/rowtypes.html https://www.postgresql.org/docs/current/rowtypes.html which gives you the best of both worlds. A single field which contains 2 fields that can later be extracted. So everywhere you can write a single field for joins, etc. But then when you need it broken out...