如何在SQLAlchemy的INSERT和UPDATE语句中设置表别名？

下面通过一个PostgreSQL示例，同时展示INSERT（含冲突处理）和UPDATE操作中表别名的用法：

CREATE TABLE person (
  id INT PRIMARY KEY,
  name CHAR(120)
);

INSERT INTO person (id, name) 
VALUES 
  (1, 'A'), 
  (2, 'B'), 
  (3, 'C'), 
  (4, 'D');

INSERT INTO person AS p (id, name) 
VALUES (1, 'A2')
ON CONFLICT (id) DO UPDATE 
SET name = EXCLUDED.name || ' (previously ' || p.name || ')';

UPDATE person AS p 
SET name = 'B2' || ' (previously ' || p.name || ')'
WHERE p.id = 2;

SELECT * 
FROM person 
ORDER BY id;

内容的提问来源于stack exchange，提问作者user2340939