join purchase using (customer_id)
They only get cumbersome when you have schemas without consistent key names, complex join conditions, insist on uppercasing reserved words, or do all sorts of formatting acrobatics.So I guess I agree with you. A well designed schema makes reading and writing SQL a pleasure