-- create table
CREATE TABLE features (
  key INTEGER,
  qualifier TEXT,
  value INTEGER
);
-- insert data
INSERT INTO features VALUES (183, 'waterproof', 1),
                            (766, 'oilfree', 0),
                            (766, 'oilfree', 1),
                            (991, 'parabenfree', 0),
                            (991, 'parabenfree', 1);

-- statement
SELECT 
    f.key,
    CASE WHEN f.qualifier LIKE '%waterproof%'
        THEN f.value END as waterproof,

    CASE WHEN f.qualifier LIKE '%parabenfree%'
        THEN f.value END as parabenfree,

    CASE WHEN f.qualifier LIKE '%oilfree%'
        THEN f.value END as oilfree
FROM 
    features f