diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-05-03 09:12:24 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-05-03 09:12:24 +0000 |
commit | 98d5537435b2951b36c45f1fda667fa27c165794 (patch) | |
tree | d26b4dfa6cf91847100fe10a94a04dcc2ad36a86 /sqlglot/dialects/sqlite.py | |
parent | Adding upstream version 11.5.2. (diff) | |
download | sqlglot-091f07175e8b976fcf301fe4832c1b7e0bc4eef0.tar.xz sqlglot-091f07175e8b976fcf301fe4832c1b7e0bc4eef0.zip |
Adding upstream version 11.7.1.upstream/11.7.1
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
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: |