Merge "establish mypy / typing approach for v2.0" into main

1 files changed, 6 insertions, 2 deletions

diff --git a/lib/sqlalchemy/engine/reflection.py b/lib/sqlalchemy/engine/reflection.py
index df7a53ab7..882392e9c 100644
--- a/lib/sqlalchemy/engine/reflection.py
+++ b/lib/sqlalchemy/engine/reflection.py
@@ -24,11 +24,13 @@ methods such as get_table_names, get_columns, etc.
    use the key 'name'. So for most return values, each record will have a
    'name' attribute..
 """
-
 import contextlib
+from typing import List
+from typing import Optional
 
 from .base import Connection
 from .base import Engine
+from .interfaces import ReflectedColumn
 from .. import exc
 from .. import inspection
 from .. import sql
@@ -433,7 +435,9 @@ class Inspector(inspection.Inspectable["Inspector"]):
                 conn, view_name, schema, info_cache=self.info_cache
             )
 
-    def get_columns(self, table_name, schema=None, **kw):
+    def get_columns(
+        self, table_name: str, schema: Optional[str] = None, **kw
+    ) -> List[ReflectedColumn]:
         """Return information about columns in `table_name`.
 
         Given a string `table_name` and an optional string `schema`, return