dosubot[bot] commented on issue #37778: URL: https://github.com/apache/superset/issues/37778#issuecomment-3864529012
<!-- Answer --> Superset is translating CEILING to CEIL because it relies on the sqlglot library to handle SQL dialects, and for SQL Server, Superset maps to sqlglot's TSQL dialect. The translation from CEILING to CEIL happens inside sqlglot's TSQL dialect rules, not in Superset itself—there are no Superset-level overrides or configuration options to change this behavior. Right now, there isn't a workaround in Superset to prevent this translation. If this is blocking, the best path is to monitor or request a fix in the upstream sqlglot project, since that's where the function mapping is controlled. More details on how Superset maps engines to dialects can be found in the code [here](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/sql/parse.py#L56-L854). <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/91c9b640-7fca-4e67-9ca9-ef5ddc0ce850?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=Superset%20is%20translating%20CEILING%20to%20CEIL%20because%20it%20relies%20on%20the%20sqlglot%20library%20to%20handle%20SQL%20dialects%2C%20and%20for%20SQL%20Server%2C%20Superset%20maps%20to%20sqlglot%27s%20TSQL%20dialect.%20The%20translation%20from%20CEILING%20to%20CEIL%20happens%20inside%20sqlglot%27s%20TSQL%20dialect%20rules%2C%20not%20in%20Superset%20itself%E2%80%94there%20are%20no%20Superset-level%20overrides%20or%20configuration%20options%20to%20change%20this%20behavior.%20Right%20now%2C%20there%20isn%27t%20a%20workaround%20in%20Superset%20to%20prevent%20this%20translation.%20If%20this%20is%20blocking%2C%20the%20best%20path%20is%20to%20monitor%20or%20request%20a%20fix%20in%20the%20upstream%20sqlglot%20project%2C%20since%20that%27s%20where%20 the%20function%20mapping%20is%20controlled.%20More%20details%20on%20how%20Superset%20maps%20engines%20to%20dialects%20can%20be%20found%20in%20the%20code%20%5Bhere%5D%28https%3A//github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/sql/parse.py%23L56-L854%29.) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/37778) -- 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]
