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.