summaryrefslogtreecommitdiffstats
path: root/sqlglot/optimizer/expand_multi_table_selects.py
diff options
context:
space:
mode:
Diffstat (limited to 'sqlglot/optimizer/expand_multi_table_selects.py')
-rw-r--r--sqlglot/optimizer/expand_multi_table_selects.py24
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