From afcab5edf6a3a6e9e83d1940d0be079e92c53e79 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 17 Jan 2021 13:35:02 -0500 Subject: Implement support for functions as FROM with columns clause support Implemented support for "table valued functions" along with additional syntaxes supported by PostgreSQL, one of the most commonly requested features. Table valued functions are SQL functions that return lists of values or rows, and are prevalent in PostgreSQL in the area of JSON functions, where the "table value" is commonly referred towards as the "record" datatype. Table valued functions are also supported by Oracle and SQL Server. Moved from I5b093b72533ef695293e737eb75850b9713e5e03 due to accidental push Fixes: #3566 Change-Id: Iea36d04c80a5ed3509dcdd9ebf0701687143fef5 --- lib/sqlalchemy/dialects/postgresql/array.py | 2 ++ 1 file changed, 2 insertions(+) (limited to 'lib/sqlalchemy/dialects/postgresql/array.py') diff --git a/lib/sqlalchemy/dialects/postgresql/array.py b/lib/sqlalchemy/dialects/postgresql/array.py index ad71db89e..91bb89ea9 100644 --- a/lib/sqlalchemy/dialects/postgresql/array.py +++ b/lib/sqlalchemy/dialects/postgresql/array.py @@ -96,6 +96,8 @@ class array(expression.ClauseList, expression.ColumnElement): __visit_name__ = "array" + stringify_dialect = "postgresql" + def __init__(self, clauses, **kw): clauses = [ coercions.expect(roles.ExpressionElementRole, c) for c in clauses -- cgit v1.2.1