49 ms·Try out SQLite FROM before SELECT in SQLite3 points by willvarfar 2y agowillvarfar 2y agoHere's an example snippet you can try out in the fiddle: WITH x AS ( SELECT 1 AS foo UNION ALL SELECT 2 AS foo ) FROM x SELECT * WHERE foo > 1