diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:02:18 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-15 05:02:18 +0000 |
| commit | 41f1f5740d2140bfd3b2a282ca1087a4b576679a (patch) | |
| tree | 0b1eb5ba5c759d08b05d56e50675784b6170f955 /sqlglot/dialects/redshift.py | |
| parent | Releasing debian version 23.7.0-1. (diff) | |
| download | sqlglot-41f1f5740d2140bfd3b2a282ca1087a4b576679a.tar.xz sqlglot-41f1f5740d2140bfd3b2a282ca1087a4b576679a.zip | |
Merging upstream version 23.10.0.
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'sqlglot/dialects/redshift.py')
| -rw-r--r-- | sqlglot/dialects/redshift.py | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/sqlglot/dialects/redshift.py b/sqlglot/dialects/redshift.py index 1f0c411..7a86c61 100644 --- a/sqlglot/dialects/redshift.py +++ b/sqlglot/dialects/redshift.py @@ -167,7 +167,11 @@ class Redshift(Postgres): exp.GroupConcat: rename_func("LISTAGG"), exp.ParseJSON: rename_func("JSON_PARSE"), exp.Select: transforms.preprocess( - [transforms.eliminate_distinct_on, transforms.eliminate_semi_and_anti_joins] + [ + transforms.eliminate_distinct_on, + transforms.eliminate_semi_and_anti_joins, + transforms.unqualify_unnest, + ] ), exp.SortKeyProperty: lambda self, e: f"{'COMPOUND ' if e.args['compound'] else ''}SORTKEY({self.format_args(*e.this)})", @@ -203,7 +207,7 @@ class Redshift(Postgres): return "" arg = self.sql(seq_get(args, 0)) - alias = self.expressions(expression.args.get("alias"), key="columns") + alias = self.expressions(expression.args.get("alias"), key="columns", flat=True) return f"{arg} AS {alias}" if alias else arg def with_properties(self, properties: exp.Properties) -> str: |