Improve from_select typing

Properly type :paramref:`_dml.Insert.from_select.names` to accept
a list of string or columns or mapped attributes.
Fixes: #9514

Change-Id: I2a3396454e79bd2113fc3d57d1252a2e6d141310

1 files changed, 6 insertions, 0 deletions

diff --git a/test/ext/mypy/plain_files/dml.py b/test/ext/mypy/plain_files/dml.py
index d2ffbf1e1..596f47795 100644
--- a/test/ext/mypy/plain_files/dml.py
+++ b/test/ext/mypy/plain_files/dml.py
@@ -5,6 +5,7 @@ from typing import Dict
 
 from sqlalchemy import Column
 from sqlalchemy import insert
+from sqlalchemy import select
 from sqlalchemy.orm import DeclarativeBase
 from sqlalchemy.orm import Mapped
 from sqlalchemy.orm import mapped_column
@@ -33,3 +34,8 @@ stmt2 = insert(User).values(d2)
 
 d3: Dict[Column[str], Any] = {}
 stmt3 = insert(User).values(d3)
+
+stmt4 = insert(User).from_select(
+    [User.id, "name", User.__table__.c.data],
+    select(User.id, User.name, User.data),
+)