Am I right that this clause is embedded in a SQL statement like

create table ... as select ... <clause> ... from <table> with data;
where <table> has columns UNIQUE_ROW_IDENTIFIER and MY_CODE ?

Yes, precisely. :)