Validate dataset's SQL query before saving changes

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

Users are able to edit existing virtual datasets, including perform modifications to the SQL query. When changes are saved, the query isn't validated so it's possible to save an incorrect dataset.

How are they solving it currently?

The SQL query is validated when clicking on Sync Columns from Source.

What is the recommended solution by the customer?

Validate the SQL query and notify the user about potential errors before saving changes to the dataset.