> A notion as simple as "I want to return a list of customers with additional properties" does not map to any dedicated SQL construct.

a temp table with unique/primary key on custumer really helps if uniqueness is a requirement.