PTT or CTE column metadata

Oracle Database 19c, RU 19.21.

Developers would find this useful: column metadata from any SELECT statement. I can simulate this and possibly get this in a procedure:

create table TEMP_QUERY as select c1, c2, c3, n1, n2, n3 from dba_tables join dba_users ... where 0=1;

select column_id, table_name, column_name, data_type, . . . from dba_tab_cols where table_name='TEMP_QUERY' order by column_id;

But for our development environment this frequent DDL ends up being a performance hit (when it happens thousands of times a minute). Less overhead would be to create a memory-resident PTT but since it's not in the data dictionary I can only see the table name, not the column attributes of the query. As a CTE,