As it seems, it's not necessary to specify the table name with !profiles if self-referencing. When using '*, creator:creator_id(id, first_name, last_name)', it works as expected.
!profiles
'*, creator:creator_id(id, first_name, last_name)'