diff options
Diffstat (limited to 'sqlglot/generator.py')
| -rw-r--r-- | sqlglot/generator.py | 10 |
1 files changed, 7 insertions, 3 deletions
diff --git a/sqlglot/generator.py b/sqlglot/generator.py index 1ce2aaa..4ac988f 100644 --- a/sqlglot/generator.py +++ b/sqlglot/generator.py @@ -1215,7 +1215,8 @@ class Generator: system_time = expression.args.get("system_time") system_time = f" {self.sql(expression, 'system_time')}" if system_time else "" - return f"{table}{system_time}{alias}{hints}{pivots}{joins}{laterals}" + sql = f"{table}{system_time}{alias}{hints}{pivots}{joins}{laterals}" + return f"({sql})" if expression.args.get("wrapped") else sql def tablesample_sql( self, expression: exp.TableSample, seed_prefix: str = "SEED", sep=" AS " @@ -2289,11 +2290,14 @@ class Generator: def function_fallback_sql(self, expression: exp.Func) -> str: args = [] - for arg_value in expression.args.values(): + + for key in expression.arg_types: + arg_value = expression.args.get(key) + if isinstance(arg_value, list): for value in arg_value: args.append(value) - else: + elif arg_value is not None: args.append(arg_value) return self.func(expression.sql_name(), *args) |