diff options
Diffstat (limited to '')
| -rw-r--r-- | sqlglot/dialects/tsql.py | 9 |
1 files changed, 8 insertions, 1 deletions
diff --git a/sqlglot/dialects/tsql.py b/sqlglot/dialects/tsql.py index fa62e78..6aa49e4 100644 --- a/sqlglot/dialects/tsql.py +++ b/sqlglot/dialects/tsql.py @@ -14,6 +14,7 @@ from sqlglot.dialects.dialect import ( parse_date_delta, rename_func, timestrtotime_sql, + ts_or_ds_to_date_sql, ) from sqlglot.expressions import DataType from sqlglot.helper import seq_get @@ -590,6 +591,7 @@ class TSQL(Dialect): NVL2_SUPPORTED = False ALTER_TABLE_ADD_COLUMN_KEYWORD = False LIMIT_FETCH = "FETCH" + COMPUTED_COLUMN_WITH_TYPE = False TYPE_MAPPING = { **generator.Generator.TYPE_MAPPING, @@ -619,7 +621,11 @@ class TSQL(Dialect): exp.Min: min_or_least, exp.NumberToStr: _format_sql, 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.eliminate_qualify, + ] ), exp.SHA: lambda self, e: self.func("HASHBYTES", exp.Literal.string("SHA1"), e.this), exp.SHA2: lambda self, e: self.func( @@ -630,6 +636,7 @@ class TSQL(Dialect): exp.TemporaryProperty: lambda self, e: "", exp.TimeStrToTime: timestrtotime_sql, exp.TimeToStr: _format_sql, + exp.TsOrDsToDate: ts_or_ds_to_date_sql("tsql"), } TRANSFORMS.pop(exp.ReturnsProperty) |