dosubot[bot] commented on issue #32879: URL: https://github.com/apache/superset/issues/32879#issuecomment-2757578333
<!-- Greeting --> Hey @torzsmokus, I'm here to help you with your Superset issue and answer any questions you might have. Let's work together to solve this! <!-- Answer --> The error message "Custom SQL fields cannot contain sub-queries" is related to the `validate_adhoc_subquery` function in Superset, which checks for sub-queries in SQL expressions and raises this error if they are not allowed <sup>[[1]](https://github.com/apache/superset/blob/master/superset/models/helpers.py)</sup>. In your case, the issue seems to be related to field names with multiple spaces. To address this, you can use the CUSTOM SQL feature to quote field names according to the SQL dialect of your data source. For MS SQL, you typically need to use square brackets around field names with spaces, like `[Jelenlét Pont címe]`. This should help Superset correctly interpret the field names and avoid the error. If you continue to encounter issues, consider checking if there are any specific configurations or feature flags that might affect SQL field name handling in your Superset setup. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/0011acb2-54d9-44a6-9dd5-02d98c6a0f15?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
