INSERT INTO temp1
SELECT pkcols, rowid
FROM tab1
WHERE whatever;

INSERT INTO temp2
SELECT pkcols, ROWID
FROM tab2
WHERE fkcols in (SELECT pkcols FROM temp1);

INSERT INTO temp3
SELECT pkcols, ROWID
FROM tab3
WHERE fkcols in (SELECT pkcols FROM temp2);

DELETE FROM temp3
WHERE ROWID IN (select rowid FROM temp3);

DELETE FROM temp2
WHERE ROWID IN (select rowid FROM temp2);

DELETE FROM temp1
WHERE ROWID IN (select rowid FROM temp1);