Attaching aliases from insert to select

[sunrutcon]

I'm able to get the list of column names from insert, but wandering how to attach or change aliases in related select query to match the insert column names.

Here is the example of sql:
-- input SQL insert into trg_Schema.trg_table ( col_name1, col_name2, col_name3 ) select (2-1), '2' as cars, 3 bicycles from dual;

Here is example of the result:
-- RESULT insert into trg_Schema.trg_table ( col_name1, col_name2, col_name3 ) select (2-1) as col_name1, '2' as col_name2, 3 as col_name3 from dual;

[georgesittas]

I recently posted an answer to a similar issue about aliases here: #2155

For your use case, you'd have to fetch insert's column names by inspecting the AST and then use them to replace the projections' aliases.

[sunrutcon]

Tnx for quick response, it works!