Add missing overload to Numeric

Added missing init overload to :class:`_sql.Numeric` to allow
type checkers to properly resolve the type var given the
``asdecimal`` parameter.

this fortunately fixes a glitch in the generate_sql_functions script
also

Fixes: #9391
Change-Id: I9cecc40c52711489e9dbe663f110c3b81c7285e4

2 files changed, 14 insertions, 2 deletions

diff --git a/test/ext/mypy/plain_files/functions.py b/test/ext/mypy/plain_files/functions.py
index ecd404010..09c2acf05 100644
--- a/test/ext/mypy/plain_files/functions.py
+++ b/test/ext/mypy/plain_files/functions.py
@@ -29,7 +29,7 @@ reveal_type(stmt3)
 
 stmt4 = select(func.cume_dist())
 
-# EXPECTED_RE_TYPE: .*Select\[Any\]
+# EXPECTED_RE_TYPE: .*Select\[Tuple\[.*Decimal\]\]
 reveal_type(stmt4)
 
 
@@ -89,7 +89,7 @@ reveal_type(stmt13)
 
 stmt14 = select(func.percent_rank())
 
-# EXPECTED_RE_TYPE: .*Select\[Any\]
+# EXPECTED_RE_TYPE: .*Select\[Tuple\[.*Decimal\]\]
 reveal_type(stmt14)
 
 
diff --git a/test/ext/mypy/plain_files/sqltypes.py b/test/ext/mypy/plain_files/sqltypes.py
new file mode 100644
index 000000000..230cb957d
--- /dev/null
+++ b/test/ext/mypy/plain_files/sqltypes.py
@@ -0,0 +1,12 @@
+from sqlalchemy import Float
+from sqlalchemy import Numeric
+
+# EXPECTED_TYPE: Float[float]
+reveal_type(Float())
+# EXPECTED_TYPE: Float[Decimal]
+reveal_type(Float(asdecimal=True))
+
+# EXPECTED_TYPE: Numeric[Decimal]
+reveal_type(Numeric())
+# EXPECTED_TYPE: Numeric[float]
+reveal_type(Numeric(asdecimal=False))