diff options
Diffstat (limited to 'sqlglot/optimizer/expand_multi_table_selects.py')
-rw-r--r-- | sqlglot/optimizer/expand_multi_table_selects.py | 24 |
1 files changed, 0 insertions, 24 deletions
diff --git a/sqlglot/optimizer/expand_multi_table_selects.py b/sqlglot/optimizer/expand_multi_table_selects.py deleted file mode 100644 index 86f0c2d..0000000 --- a/sqlglot/optimizer/expand_multi_table_selects.py +++ /dev/null @@ -1,24 +0,0 @@ -from sqlglot import exp - - -def expand_multi_table_selects(expression): - """ - Replace multiple FROM expressions with JOINs. - - Example: - >>> from sqlglot import parse_one - >>> expand_multi_table_selects(parse_one("SELECT * FROM x, y")).sql() - 'SELECT * FROM x CROSS JOIN y' - """ - for from_ in expression.find_all(exp.From): - parent = from_.parent - - for query in from_.expressions[1:]: - parent.join( - query, - join_type="CROSS", - copy=False, - ) - from_.expressions.remove(query) - - return expression |