discovered this error when working with one of the NF tables on Synapse (syn16857542).
We have a column called 'year'.
If the query is written as: `SELECT year FROM syn16857542` we get the error `Unknown column 'YEAR' in 'field list' `
If it is written as `SELECT 'year' FROM syn16857542` the query works fine.
I saw this in SWC, and Andrew observed this in the python client, so we're guessing it has something to do with YEAR being a function that is surfaced in synapse.
edit: From my perspective the bug here is the error, which is not informative to the end user.