Merge "add joins_implicitly to column_valued()" into main

1 files changed, 12 insertions, 2 deletions

diff --git a/lib/sqlalchemy/sql/functions.py b/lib/sqlalchemy/sql/functions.py
index 5ed89bc82..742f211c9 100644
--- a/lib/sqlalchemy/sql/functions.py
+++ b/lib/sqlalchemy/sql/functions.py
@@ -292,7 +292,7 @@ class FunctionElement(Executable, ColumnElement[_T], FromClause, Generative):
 
         return new_func.alias(name=name, joins_implicitly=joins_implicitly)
 
-    def column_valued(self, name=None):
+    def column_valued(self, name=None, joins_implicitly=False):
         """Return this :class:`_functions.FunctionElement` as a column expression that
         selects from itself as a FROM clause.
 
@@ -308,6 +308,16 @@ class FunctionElement(Executable, ColumnElement[_T], FromClause, Generative):
 
             gs = func.generate_series(1, 5, -1).alias().column
 
+        :param name: optional name to assign to the alias name that's generated.
+         If omitted, a unique anonymizing name is used.
+
+        :param joins_implicitly: when True, the "table" portion of the column
+         valued function may be a member of the FROM clause without any
+         explicit JOIN to other tables in the SQL query, and no "cartesian
+         product" warning will be generated. May be useful for SQL functions
+         such as ``func.json_array_elements()``.
+
+         .. versionadded:: 1.4.46
 
         .. seealso::
 
@@ -319,7 +329,7 @@ class FunctionElement(Executable, ColumnElement[_T], FromClause, Generative):
 
         """  # noqa: 501
 
-        return self.alias(name=name).column
+        return self.alias(name=name, joins_implicitly=joins_implicitly).column
 
     @util.ro_non_memoized_property
     def columns(self):