Table literal in SQLite

table_literal.sql

select * from (
  -- define the column names
	select 0 as a, 0 as b 
	
	-- join the definition row with all the values
	union 
	
	-- define the values
	values 
	    	(4,5), 
	    	(5,6),
	    	(6,7),
	    	(7,8),
	    	(9,10),
	    	(11,12)
    	
) 
-- skip the definition row
limit -1 offset 1;


--> /*
"a"	"b"
===	===
"4"	"5"
"5"	"6"
"6"	"7"
"7"	"8"
"9"	"10"
"11"	"12"

*/

To create multiple rows, keep appending tuples:

sqlite> SELECT * FROM (VALUES (1, 'hi'), (2, 'there'));
column1  column2
-------  -------
1        hi
2        there

Found this in the grammar for SELECT https://www.sqlite.org/lang_select.html