Something seems to be mutating sqlalchemy expressions #127
Labels
api: bigquery
Issues related to the googleapis/python-bigquery-sqlalchemy API.
🚨
This issue needs some love.
triage me
I really want to be triaged.
Uh oh!
There was an error while loading. Please reload this page.
Hey, thanks for all your work on this library! I'm looking into adding bigquery support to siuba--which makes heavy use of sqlalchemy--and ran into a small hitch with expressions producing different SQL when run multiple times. AFAIK these expressions should be immutable at this level of use, so I wonder if pybigquery is doing some kind of mutation under the hood?
Environment details
Steps to reproduce
Run the following code to setup:
Note that running the following code returns a valid SQL query:
Output:
However, if we re-run only the last two lines, it produces a new (invalid) query, which prefixes column names with
`anon_1`.`my_dataset`
:output
I wonder if it's related to the use_label attribute being set (#78), since it's mutating an element attribute.
The text was updated successfully, but these errors were encountered: