sqlglot.dialects.sqlite

15class SQLite(Dialect):
16    # https://sqlite.org/forum/forumpost/5e575586ac5c711b?raw
17    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_INSENSITIVE
18    ASCII_ONLY_NORMALIZATION = True
19    TYPED_DIVISION = True
20    SAFE_DIVISION = True
21    SAFE_TO_ELIMINATE_DOUBLE_NEGATION = False
22    USING_COLUMN_ORDER = UsingColumnOrder.IN_PLACE
23    CONCAT_COALESCE = True
24    CONCAT_WS_COALESCE = True
25    INTERSECT_BINDS_TIGHTER_THAN_UNION_AND_EXCEPT = False
26
27    class Tokenizer(tokens.Tokenizer):
28        IDENTIFIERS = ['"', ("[", "]"), "`"]
29        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", ""), ("0X", "")]
30
31        NESTED_COMMENTS = False
32        COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
33
34        KEYWORDS = {
35            **tokens.Tokenizer.KEYWORDS,
36            "ATTACH": TokenType.ATTACH,
37            "DETACH": TokenType.DETACH,
38            # REAL, FLOAT and DOUBLE are all 8-byte IEEE floats in SQLite (REAL affinity),
39            # so they must not become a 4-byte float in dialects where REAL/FLOAT means FLOAT4
40            "FLOAT": TokenType.DOUBLE,
41            "INDEXED BY": TokenType.INDEXED_BY,
42            "MATCH": TokenType.MATCH,
43            "REAL": TokenType.DOUBLE,
44        }
45
46        KEYWORDS.pop("/*+")
47
48        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE}
49
50    Parser = SQLiteParser
51
52    Generator = SQLiteGenerator

27    class Tokenizer(tokens.Tokenizer):
28        IDENTIFIERS = ['"', ("[", "]"), "`"]
29        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", ""), ("0X", "")]
30
31        NESTED_COMMENTS = False
32        COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
33
34        KEYWORDS = {
35            **tokens.Tokenizer.KEYWORDS,
36            "ATTACH": TokenType.ATTACH,
37            "DETACH": TokenType.DETACH,
38            # REAL, FLOAT and DOUBLE are all 8-byte IEEE floats in SQLite (REAL affinity),
39            # so they must not become a 4-byte float in dialects where REAL/FLOAT means FLOAT4
40            "FLOAT": TokenType.DOUBLE,
41            "INDEXED BY": TokenType.INDEXED_BY,
42            "MATCH": TokenType.MATCH,
43            "REAL": TokenType.DOUBLE,
44        }
45
46        KEYWORDS.pop("/*+")
47
48        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE}