PostgreSQL: psycopg2.errors.UndefinedTable: invalid reference to FROM-clause entry for table

Есть такой запрос к Postgre:

-- Insert records
INSERT INTO target.table (
            collect_project_id,
            project_number,
            project_name,
            connect_project_id,
            project_desc,
            project_type,
            project_status,
            project_path,
            language_code,
            country_code,
            timezone,
            date_created,
            date_updated
            )

WITH temp AS 
(SELECT id, number, name, connect_project_id, description, type, status, path, language, country, timezone, created, modified
FROM source.table 
WHERE (source.table  > getdate() - interval '30 minutes' OR source.table.projects.modified > getdate() - interval '30 minutes'))
 
SELECT id, number, name, connect_project_id, description, type, status, path, language, country, timezone, created, modified
FROM temp
WHERE target.table.collect_project_id != temp.id ;

В общем, суть моего запроса в том, чтобы скопировать из source.table в target.table данные, если target.table.collect_project_id != source.table.id

Но получаю ошибку:

psycopg2.errors.UndefinedTable: invalid reference to FROM-clause entry for table "dim_collect_projects"
HINT:  There is an entry for table "dim_collect_projects", but it cannot be referenced from this part of the query.