diff options
Diffstat (limited to 'sqlglot/dialects/sqlite.py')
-rw-r--r-- | sqlglot/dialects/sqlite.py | 6 |
1 files changed, 4 insertions, 2 deletions
diff --git a/sqlglot/dialects/sqlite.py b/sqlglot/dialects/sqlite.py index 1fa730d..e55a3b8 100644 --- a/sqlglot/dialects/sqlite.py +++ b/sqlglot/dialects/sqlite.py @@ -5,6 +5,7 @@ import typing as t from sqlglot import exp, generator, parser, tokens, transforms from sqlglot.dialects.dialect import ( Dialect, + NormalizationStrategy, any_value_to_max_sql, arrow_json_extract_scalar_sql, arrow_json_extract_sql, @@ -63,8 +64,10 @@ def _transform_create(expression: exp.Expression) -> exp.Expression: class SQLite(Dialect): # https://sqlite.org/forum/forumpost/5e575586ac5c711b?raw - RESOLVES_IDENTIFIERS_AS_UPPERCASE = None + NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_INSENSITIVE SUPPORTS_SEMI_ANTI_JOIN = False + TYPED_DIVISION = True + SAFE_DIVISION = True class Tokenizer(tokens.Tokenizer): IDENTIFIERS = ['"', ("[", "]"), "`"] @@ -124,7 +127,6 @@ class SQLite(Dialect): exp.LogicalOr: rename_func("MAX"), exp.LogicalAnd: rename_func("MIN"), exp.Pivot: no_pivot_sql, - exp.SafeConcat: concat_to_dpipe_sql, exp.Select: transforms.preprocess( [ transforms.eliminate_distinct_on, |