drop table if exists tangotemp; 

create table tangotemp (
  color  varchar(255)
);

insert into tangotemp values
   ('light scarletred'),
   ('scarletred'),
   ('dark scarletred'),
   ('light plum'),
   ('plum'),
   ('dark plum'),
   ('light skyblue'),
   ('skyblue'),
   ('dark skyblue'),
   ('light chameleon'),
   ('chameleon'),
   ('dark chameleon'),
   ('light butter'),
   ('butter'),
   ('dark butter'),
   ('light tangoorange'),
   ('tangoorange'),
   ('dark tangoorange')
;

plot piechart
  pievalues, pielabels, color override
select
  10, color, color from tangotemp;