diff options
Diffstat (limited to 'sqlglot/transforms.py')
-rw-r--r-- | sqlglot/transforms.py | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/sqlglot/transforms.py b/sqlglot/transforms.py index 99949a1..35ff75a 100644 --- a/sqlglot/transforms.py +++ b/sqlglot/transforms.py @@ -82,6 +82,27 @@ def eliminate_distinct_on(expression: exp.Expression) -> exp.Expression: return expression +def remove_precision_parameterized_types(expression: exp.Expression) -> exp.Expression: + """ + Some dialects only allow the precision for parameterized types to be defined in the DDL and not in other expressions. + This transforms removes the precision from parameterized types in expressions. + """ + return expression.transform( + lambda node: exp.DataType( + **{ + **node.args, + "expressions": [ + node_expression + for node_expression in node.expressions + if isinstance(node_expression, exp.DataType) + ], + } + ) + if isinstance(node, exp.DataType) + else node, + ) + + def preprocess( transforms: t.List[t.Callable[[exp.Expression], exp.Expression]], to_sql: t.Callable[[Generator, exp.Expression], str], @@ -121,3 +142,6 @@ def delegate(attr: str) -> t.Callable: UNALIAS_GROUP = {exp.Group: preprocess([unalias_group], delegate("group_sql"))} ELIMINATE_DISTINCT_ON = {exp.Select: preprocess([eliminate_distinct_on], delegate("select_sql"))} +REMOVE_PRECISION_PARAMETERIZED_TYPES = { + exp.Cast: preprocess([remove_precision_parameterized_types], delegate("cast_sql")) +} |