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.
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: