dosubot[bot] commented on issue #33557: URL: https://github.com/apache/superset/issues/33557#issuecomment-2900181897
<!-- Answer --> I understand your need to use spaces in column aliases with AS, especially since this worked in Superset 3.1.1 but is now causing issues in 4.1.2. Based on what I found, there is no documentation or changelog entry that explains a change in SQL alias handling or parsing between these versions, and nothing specifically addresses this regression or limitation in the official sources I checked. The error message you see—"Custom SQL fields cannot contain subqueries"—is a recognized error in the Superset codebase, but there is no further explanation or workaround documented for your specific scenario. This suggests that the issue may be due to a change in how Superset parses or validates custom SQL fields when saving datasets or generating charts, possibly introducing stricter checks or a bug that affects aliases with spaces. Unfortunately, I could not find any configuration option or setting in 4.1.2 that would allow you to restore the previous behavior or explicitly permit spaces in column aliases. If you need to keep spaces in your column names for display purposes, and the workarounds (such as using underscores or ASCII-only names) are not acceptable, this may be a regression or unintended side effect in the newer version. Since there is no documented fix or workaround, the best next step would be to report this as a potential bug with a minimal reproducible example, highlighting that it worked in 3.1.1 but not in 4.1.2. If you have access to Superset logs or stack traces when the error occurs, including those details could help the maintainers diagnose the root cause more quickly. Let me know if you want help narrowing down the cause further or if you have more details from logs that could help with troubleshooting. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://go.dosu.dev/dosubot), mention @dosu-bot.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/553f9dc4-30c2-4da5-8511-b0367faa5590?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]
