]> git.ipfire.org Git - thirdparty/sqlalchemy/sqlalchemy.git/commit
Implement support for functions as FROM with columns clause support
authorMike Bayer <mike_mp@zzzcomputing.com>
Sun, 17 Jan 2021 18:35:02 +0000 (13:35 -0500)
committerMike Bayer <mike_mp@zzzcomputing.com>
Wed, 3 Feb 2021 20:52:17 +0000 (15:52 -0500)
commitafcab5edf6a3a6e9e83d1940d0be079e92c53e79
treedcca718f11a4943b4e32ff0559fd67ad439c1dcf
parenta7eeac60cae28bb553327d317a88adb22c799ef3
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
32 files changed:
doc/build/changelog/unreleased_14/3566.rst [new file with mode: 0644]
doc/build/core/functions.rst
doc/build/core/selectable.rst
doc/build/dialects/postgresql.rst
doc/build/orm/join_conditions.rst
doc/build/tutorial/data.rst
lib/sqlalchemy/dialects/oracle/base.py
lib/sqlalchemy/dialects/postgresql/array.py
lib/sqlalchemy/dialects/postgresql/base.py
lib/sqlalchemy/sql/base.py
lib/sqlalchemy/sql/coercions.py
lib/sqlalchemy/sql/compiler.py
lib/sqlalchemy/sql/elements.py
lib/sqlalchemy/sql/expression.py
lib/sqlalchemy/sql/functions.py
lib/sqlalchemy/sql/roles.py
lib/sqlalchemy/sql/selectable.py
lib/sqlalchemy/sql/sqltypes.py
lib/sqlalchemy/sql/traversals.py
lib/sqlalchemy/sql/type_api.py
lib/sqlalchemy/sql/visitors.py
lib/sqlalchemy/testing/requirements.py
lib/sqlalchemy/testing/suite/test_select.py
test/dialect/mssql/test_query.py
test/dialect/oracle/test_compiler.py
test/dialect/oracle/test_dialect.py
test/dialect/postgresql/test_query.py
test/requirements.py
test/sql/test_compare.py
test/sql/test_functions.py
test/sql/test_lateral.py
test/sql/test_roles.py