CREATE TABLE reading (id INTEGER, sensor TEXT, value INTEGER);
INSERT INTO reading VALUES (1, 'temp', 20), (2, 'temp', -1), (3, 'temp', 22);
-- NULLIF(value, -1) yields NULL when value equals the sentinel -1
SELECT sensor, NULLIF(value, -1) AS clean_value
FROM reading;

NULLIF turns a sentinel into NULL