dosubot[bot] commented on issue #31307: URL: https://github.com/apache/superset/issues/31307#issuecomment-2520867651
<!-- Answer --> The issue you're encountering seems to be related to how Superset's SQL parsing logic handles double-quoted aliases in PostgreSQL queries. In Superset version 4.1.1, there might have been changes in the SQL parsing logic that affect how these queries are processed, especially when schema-specific permissions are involved. Superset uses `sqlglot` for SQL parsing, and it maps PostgreSQL to the `sqlglot` dialect `Dialects.POSTGRES` <sup>[[1]](https://github.com/apache/superset/blob/master/superset/sql/parse.py)</sup>. Parsing issues can occur if the SQL is reformatted in a way that breaks its execution, which might be happening with your double-quoted aliases. One potential workaround is to ensure that the SQL dialect is correctly set to PostgreSQL in your Superset configuration, which might help in handling the queries as expected. However, since this issue is specific to schema permissions, it might require a deeper investigation into how permissions are managed in your Superset setup. If the problem persists, you might need to explore adjusting the SQL parsing or formatting settings in Superset or consider contributing a fix if you identify a specific bug in the parsing logic. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* -- 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]
