CREATE TABLE item (id INTEGER, name TEXT, price REAL);
INSERT INTO item VALUES (1, 'widget', 2.567), (2, 'gadget', 9.914);
-- scalar functions reshape each value
SELECT UPPER(name) AS name, ROUND(price, 2) AS price
FROM item;

UPPER and ROUND in a projection