How can I query a list of values into a column of rows using SQLite?
VALUES 'john', 'mary', 'paul';

john
mary
paul

SELECT 'john' AS name
UNION ALL SELECT 'mary' AS name
UNION ALL SELECT 'paul' AS name;

SELECT 'john' AS name
UNION ALL SELECT 'mary'
UNION ALL SELECT 'paul';