Replies: 1 comment 1 reply
-
|
you could run a custom transform or perhaps use the optimizer https://github.com/tobymao/sqlglot/blob/main/posts/ast_primer.md https://github.com/tobymao/sqlglot/tree/main/sqlglot/optimizer |
Beta Was this translation helpful? Give feedback.
1 reply
-
|
I've tried this and it does not remove the subquery. Do you want me to add some examples? |
Beta Was this translation helpful? Give feedback.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have a large set of queries written for mysql 5.7. Some of these include correlated subqueries.
Now when trying to transpile these into snowflake I have not been able to have the subqueries removed and replaces with CTEs. Making the transpiled queries not run in snowflake..
Is this possible in the current state with some settings?
Beta Was this translation helpful? Give feedback.
All reactions