The affected_rows identifier is the name of the common table expression, they're just doing: select * from affected_rows With some additional column

The affected_rows identifier is the name of the common table expression, they're just doing: select * from affected_rows With some additional columns that happen to be provided by postgres and/or a parameter to the SQL statement.