Sometimes, when writing queries like this one:

SELECT *
FROM (
  SELECT first_name, last_name
  FROM actor
) t;

I'd like to be able to quickly transform the above to an equivalent query using a CTE as follows:

WITH t AS (
  SELECT first_name, last_name
  FROM actor
)
SELECT *
FROM t;

Or, alternatively, to this:

CREATE OR REPLACE FORCE VIEW t 
AS
SELECT first_name, last_name
FROM actor;

SELECT *
FROM t;

The inverse transformations should be possible as well.