From 81edda745396715367ecd92bca051cc3b46f6936 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Yannick=20P=C3=89ROUX?= Date: Tue, 4 Nov 2025 11:28:25 +0100 Subject: [PATCH] Fix func.coalesce when used with @hybrid_property --- lib/sqlalchemy/sql/functions.py | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py index d4aafd3625..10ae5b391f 100644 --- a/lib/sqlalchemy/sql/functions.py +++ b/lib/sqlalchemy/sql/functions.py @@ -1076,7 +1076,7 @@ class _FunctionGenerator: @overload def coalesce( self, - col: _ColumnExpressionArgument[_T], + col: _ColumnExpressionArgument[Optional[_T]], *args: _ColumnExpressionOrLiteralArgument[Any], **kwargs: Any, ) -> coalesce[_T]: ... @@ -1084,14 +1084,14 @@ class _FunctionGenerator: @overload def coalesce( self, - col: _T, + col: Optional[_T], *args: _ColumnExpressionOrLiteralArgument[Any], **kwargs: Any, ) -> coalesce[_T]: ... def coalesce( self, - col: _ColumnExpressionOrLiteralArgument[_T], + col: _ColumnExpressionOrLiteralArgument[Optional[_T]], *args: _ColumnExpressionOrLiteralArgument[Any], **kwargs: Any, ) -> coalesce[_T]: ... -- 2.47.3