Understanding Tricky Joins and Multi-Table Updates in PostgreSQL (Using (build.affinity.co)