dosubot[bot] commented on issue #36860: URL: https://github.com/apache/superset/issues/36860#issuecomment-3701791409
<!-- Answer --> The main code for parsing and constructing SQL statements—including CREATE VIEW for Oracle—is in superset/sql/parse.py. The SQLStatement class (and related SQLScript class) uses sqlglot to parse SQL, extract tables, and rewrite statements as CREATE TABLE or CREATE VIEW AS, with dialect-specific logic for Oracle and others. Schema and table naming are handled by the Table dataclass in the same file, which ensures proper qualification and quoting. If you want to adjust how Superset builds or parses CREATE VIEW statements for Oracle (e.g., to fix quoting or schema handling), start with superset/sql/parse.py, especially the SQLStatement and Table classes. You may also want to review OracleEngineSpec for engine-specific quoting rules and identifier limits. [Source: superset/sql/parse.py](https://github.com/apache/superset/blob/master/superset/sql/parse.py) <!-- 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/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/93db7a7f-9546-4592-b908-85e9809404f5?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github) [](https://cursor.com/link/prompt?text=The%20main%20code%20for%20parsing%20and%20constructing%20SQL%20statements%E2%80%94including%20CREATE%20VIEW%20for%20Oracle%E2%80%94is%20in%20superset/sql/parse.py.%20The%20SQLStatement%20class%20%28and%20related%20SQLScript%20class%29%20uses%20sqlglot%20to%20parse%20SQL%2C%20extract%20tables%2C%20and%20rewrite%20statements%20as%20CREATE%20TABLE%20or%20CREATE%20VIEW%20AS%2C%20with%20dialect-specific%20logic%20for%20Oracle%20and%20others.%20Schema%20and%20table%20naming%20are%20handled%20by%20the%20Table%20dataclass%20in%20the%20same%20file%2C%20which%20ensures%20proper%20qualification%20and%20quoting.%20If%20you%20want%20to%20adjust%20how%20Superset%20builds%20or%20parses%20CREATE%20VIEW%20statements%20for%20Oracle%20%28e.g.%2C%20to%20fix%20quoting% 20or%20schema%20handling%29%2C%20start%20with%20superset/sql/parse.py%2C%20especially%20the%20SQLStatement%20and%20Table%20classes.%20You%20may%20also%20want%20to%20review%20OracleEngineSpec%20for%20engine-specific%20quoting%20rules%20and%20identifier%20limits.%20%20%0A%5BSource%3A%20superset/sql/parse.py%5D%28https%3A//github.com/apache/superset/blob/master/superset/sql/parse.py%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/36860) -- 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]
