Try out SQLite FROM before SELECT in SQLite (sqlite.org)

Here'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