Sqlglot changes the way that some Trino queries are formatted.
How to reproduce the bug
go to sqllab
type in a NOT IN query
Save it as a dataset
view the dataset query
Notice that it goes from NOT IN to WHERE NOT ... IN which won't work with Trino
Screenshots/recordings
No response
Superset version
master / latest-dev
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist
[X] I have searched Superset docs and Slack and didn't find a solution to my problem.
[X] I have searched the GitHub issue tracker and didn't find a similar bug report.
[X] I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.
Bug description
Sqlglot changes the way that some Trino queries are formatted.
How to reproduce the bug
NOT INqueryNotice that it goes from
NOT INtoWHERE NOT ... INwhich won't work with TrinoScreenshots/recordings
No response
Superset version
master / latest-dev
Python version
3.9
Node version
16
Browser
Chrome
Additional context
No response
Checklist