SQL Lab + Postgres bug with quotes (psycopg2.ProgrammingError)

[oxystin]

[Make]sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.22.1

Expected results

Workable visualization

Actual results

1. Simple Query

SELECT "SCHEDULED_ARRIVAL",
       "COUNTRY"
FROM public.flights
WHERE "DAY_OF_WEEK"='4'

2. Click "Visualize"and get the error "psycopg2.ProgrammingError column "scheduled_arrival" does not exist"

SUM value without quotes is passed to the query:

Tell me how it can be quickly fixed?
Thank you.

Steps to reproduce

[rumbin]

When it comes to fixing this issue, I'd like to remind that - if quotes were to be generally introduced for column names -
we'll risk the same kind of regression that once was observed for quoted temporal column names: #3844

[rumbin]

As a quick workaround, it may work if you simply specify the capitalized column name in the Expression field of the column's definition.

[oxystin]

@rumbin Thanks for the answer. I'll try your recipe.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions. For admin, please label this issue .pinned to prevent stale bot from closing the issue.