summaryrefslogtreecommitdiffstats
path: root/sqlglot/optimizer/quote_identities.py
diff options
context:
space:
mode:
Diffstat (limited to 'sqlglot/optimizer/quote_identities.py')
-rw-r--r--sqlglot/optimizer/quote_identities.py25
1 files changed, 25 insertions, 0 deletions
diff --git a/sqlglot/optimizer/quote_identities.py b/sqlglot/optimizer/quote_identities.py
new file mode 100644
index 0000000..17623cc
--- /dev/null
+++ b/sqlglot/optimizer/quote_identities.py
@@ -0,0 +1,25 @@
+from sqlglot import exp
+
+
+def quote_identities(expression):
+ """
+ Rewrite sqlglot AST to ensure all identities are quoted.
+
+ Example:
+ >>> import sqlglot
+ >>> expression = sqlglot.parse_one("SELECT x.a AS a FROM db.x")
+ >>> quote_identities(expression).sql()
+ 'SELECT "x"."a" AS "a" FROM "db"."x"'
+
+ Args:
+ expression (sqlglot.Expression): expression to quote
+ Returns:
+ sqlglot.Expression: quoted expression
+ """
+
+ def qualify(node):
+ if isinstance(node, exp.Identifier):
+ node.set("quoted", True)
+ return node
+
+ return expression.transform(qualify, copy=False)