diff options
Diffstat (limited to 'sqlglot/dialects/sqlite.py')
-rw-r--r-- | sqlglot/dialects/sqlite.py | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/sqlglot/dialects/sqlite.py b/sqlglot/dialects/sqlite.py index 4091dbb..4437f82 100644 --- a/sqlglot/dialects/sqlite.py +++ b/sqlglot/dialects/sqlite.py @@ -16,7 +16,7 @@ from sqlglot.tokens import TokenType def _date_add_sql(self, expression): modifier = expression.expression - modifier = expression.name if modifier.is_string else self.sql(modifier) + modifier = modifier.name if modifier.is_string else self.sql(modifier) unit = expression.args.get("unit") modifier = f"'{modifier} {unit.name}'" if unit else f"'{modifier}'" return self.func("DATE", expression.this, modifier) @@ -38,6 +38,9 @@ class SQLite(Dialect): } class Generator(generator.Generator): + JOIN_HINTS = False + TABLE_HINTS = False + TYPE_MAPPING = { **generator.Generator.TYPE_MAPPING, # type: ignore exp.DataType.Type.BOOLEAN: "INTEGER", @@ -82,6 +85,11 @@ class SQLite(Dialect): exp.TryCast: no_trycast_sql, } + PROPERTIES_LOCATION = { + **generator.Generator.PROPERTIES_LOCATION, # type: ignore + exp.VolatileProperty: exp.Properties.Location.UNSUPPORTED, + } + LIMIT_FETCH = "LIMIT" def cast_sql(self, expression: exp.Cast) -> str: |