Discrete palettes for ordinal scales

[teunbrand]

I feel like there has got to be a way to manually assign values to breaks.
Like in the plot below, I'd expect the Gentoo path to be very thick, not very thin.

FROM ggsql:penguins
VISUALISE bill_len AS x, bill_dep AS y, species AS stroke, species AS linewidth
  DRAW path
  SCALE linewidth
    FROM ('Adelie', 'Chinstrap', 'Gentoo')
    TO (1, 0.1, 10)

If this behaviour already exists with some incantation I'm unaware of, maybe we should advertise this a bit more.