Improve SQL syntax highlight and validation for calculated columns and metrics

What is the problem or goal the end user is trying to solve or accomplish?

When creating new calculated columns and metrics on the dataset, users would like to have improved autocomplete functionality (for column names, etc) and better syntax highlighting (with colors). It would also be beneficial if the syntax is validated.

How are they solving it currently?

Users can validate the custom SQL syntax on the SQL lab and then use it on the metrics/calculated columns. SQL validation only happens after defining the syntax and using it in a chart.

What is the recommended solution by the Customer?

Improve auto-complete and syntax highlight for these fields. Also provide a way to test the syntax before saving the configuration.