Open
Description
If bigquery is installed, the unnest
function (defined here) overrides the unnest
function for all dialects.
In PostgreSQL usage of unnest
is allowed with column identifiers (unnesting an array contained in a table column). But the global re-definition of unnest caused by bigquery makes code like this sa.func.unnest(some_column)
fail with TypeError: The argument to unnest must have an ARRAY type.
because, obviously, a column is not an array literal.
In my case I really do need many dialects installed at the same time.
Metadata
Metadata
Assignees
Labels
Issues related to the googleapis/python-bigquery-sqlalchemy API.Issues related to the googleapis/python-bigquery-sqlalchemy API.Moderately-important priority. Fix may not be included in next release.Moderately-important priority. Fix may not be included in next release.‘Nice-to-have’ improvement, new feature or different behavior or design.‘Nice-to-have’ improvement, new feature or different behavior or design.