Edit on GitHub

sqlglot.dialects.mysql 

  1from __future__ import annotations
  2
  3from sqlglot import tokens
  4from sqlglot.dialects.dialect import (
  5    Dialect,
  6    NormalizationStrategy,
  7    UsingColumnOrder,
  8)
  9from sqlglot.generators.mysql import MySQLGenerator
 10from sqlglot.parsers.mysql import MySQLParser
 11from sqlglot.tokens import TokenType
 12from sqlglot.typing.mysql import EXPRESSION_METADATA
 13
 14
 15class MySQL(Dialect):
 16    PROMOTE_TO_INFERRED_DATETIME_TYPE = True
 17    USING_COLUMN_ORDER = UsingColumnOrder.LEFT_TABLE
 18
 19    # https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
 20    IDENTIFIERS_CAN_START_WITH_DIGIT = True
 21
 22    # We default to treating all identifiers as case-sensitive, since it matches MySQL's
 23    # behavior on Linux systems. For MacOS and Windows systems, one can override this
 24    # setting by specifying `dialect="mysql, normalization_strategy = lowercase"`.
 25    #
 26    # See also https://dev.mysql.com/doc/refman/8.2/en/identifier-case-sensitivity.html
 27    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
 28
 29    TIME_FORMAT = "'%Y-%m-%d %T'"
 30    DPIPE_IS_STRING_CONCAT = False
 31    CONCAT_WS_COALESCE = True
 32    SUPPORTS_USER_DEFINED_TYPES = False
 33    SAFE_DIVISION = True
 34    SAFE_TO_ELIMINATE_DOUBLE_NEGATION = False
 35    LEAST_GREATEST_IGNORES_NULLS = False
 36
 37    EXPRESSION_METADATA = EXPRESSION_METADATA.copy()
 38
 39    # https://prestodb.io/docs/current/functions/datetime.html#mysql-date-functions
 40    TIME_MAPPING = {
 41        "%M": "%B",
 42        "%c": "%-m",
 43        "%e": "%-d",
 44        "%h": "%I",
 45        "%i": "%M",
 46        "%s": "%S",
 47        "%u": "%W",
 48        "%k": "%-H",
 49        "%l": "%-I",
 50        "%r": "%I:%M:%S %p",
 51        "%T": "%H:%M:%S",
 52        "%W": "%A",
 53        "%x": "%G",
 54        # %v (ISO week) is unmapped due to collision with %V (roundtrip issue)
 55    }
 56
 57    VALID_INTERVAL_UNITS = {
 58        *Dialect.VALID_INTERVAL_UNITS,
 59        "SECOND_MICROSECOND",
 60        "MINUTE_MICROSECOND",
 61        "MINUTE_SECOND",
 62        "HOUR_MICROSECOND",
 63        "HOUR_SECOND",
 64        "HOUR_MINUTE",
 65        "DAY_MICROSECOND",
 66        "DAY_SECOND",
 67        "DAY_MINUTE",
 68        "DAY_HOUR",
 69        "YEAR_MONTH",
 70    }
 71
 72    UNESCAPED_SEQUENCES = {
 73        "\\0": "\0",
 74        "\\Z": "\x1a",
 75        "\\%": "\\%",
 76        "\\_": "\\_",
 77        "\\a": "a",
 78        "\\f": "f",
 79        "\\v": "v",
 80    }
 81
 82    class Tokenizer(tokens.Tokenizer):
 83        QUOTES = ["'", '"']
 84        COMMENTS = ["--", "#", ("/*", "*/")]
 85        IDENTIFIERS = ["`"]
 86        STRING_ESCAPES = ["'", '"', "\\"]
 87        BIT_STRINGS = [("b'", "'"), ("B'", "'"), ("0b", "")]
 88        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", "")]
 89        # https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
 90        DROP_UNKNOWN_ESCAPES = True
 91
 92        NESTED_COMMENTS = False
 93        DASH_COMMENT_REQUIRES_BOUNDARY = True
 94        COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
 95
 96        KEYWORDS = {
 97            **tokens.Tokenizer.KEYWORDS,
 98            "BLOB": TokenType.BLOB,
 99            "CHARSET": TokenType.CHARACTER_SET,
100            "DISTINCTROW": TokenType.DISTINCT,
101            "EXPLAIN": TokenType.DESCRIBE,
102            "FORCE": TokenType.FORCE,
103            "IGNORE": TokenType.IGNORE,
104            "KEY": TokenType.KEY,
105            "LOCK TABLES": TokenType.COMMAND,
106            "LONGBLOB": TokenType.LONGBLOB,
107            "LONGTEXT": TokenType.LONGTEXT,
108            "MEDIUMBLOB": TokenType.MEDIUMBLOB,
109            "MEDIUMINT": TokenType.MEDIUMINT,
110            "MEDIUMTEXT": TokenType.MEDIUMTEXT,
111            "MEMBER OF": TokenType.MEMBER_OF,
112            "MOD": TokenType.MOD,
113            "SEPARATOR": TokenType.SEPARATOR,
114            "SERIAL": TokenType.SERIAL,
115            "SIGNED": TokenType.BIGINT,
116            "SIGNED INTEGER": TokenType.BIGINT,
117            "START": TokenType.BEGIN,
118            "TIMESTAMP": TokenType.TIMESTAMPTZ,
119            "TINYBLOB": TokenType.TINYBLOB,
120            "TINYTEXT": TokenType.TINYTEXT,
121            "UNLOCK TABLES": TokenType.COMMAND,
122            "UNSIGNED": TokenType.UBIGINT,
123            "UNSIGNED INTEGER": TokenType.UBIGINT,
124            "YEAR": TokenType.YEAR,
125            "_ARMSCII8": TokenType.INTRODUCER,
126            "_ASCII": TokenType.INTRODUCER,
127            "_BIG5": TokenType.INTRODUCER,
128            "_BINARY": TokenType.INTRODUCER,
129            "_CP1250": TokenType.INTRODUCER,
130            "_CP1251": TokenType.INTRODUCER,
131            "_CP1256": TokenType.INTRODUCER,
132            "_CP1257": TokenType.INTRODUCER,
133            "_CP850": TokenType.INTRODUCER,
134            "_CP852": TokenType.INTRODUCER,
135            "_CP866": TokenType.INTRODUCER,
136            "_CP932": TokenType.INTRODUCER,
137            "_DEC8": TokenType.INTRODUCER,
138            "_EUCJPMS": TokenType.INTRODUCER,
139            "_EUCKR": TokenType.INTRODUCER,
140            "_GB18030": TokenType.INTRODUCER,
141            "_GB2312": TokenType.INTRODUCER,
142            "_GBK": TokenType.INTRODUCER,
143            "_GEOSTD8": TokenType.INTRODUCER,
144            "_GREEK": TokenType.INTRODUCER,
145            "_HEBREW": TokenType.INTRODUCER,
146            "_HP8": TokenType.INTRODUCER,
147            "_KEYBCS2": TokenType.INTRODUCER,
148            "_KOI8R": TokenType.INTRODUCER,
149            "_KOI8U": TokenType.INTRODUCER,
150            "_LATIN1": TokenType.INTRODUCER,
151            "_LATIN2": TokenType.INTRODUCER,
152            "_LATIN5": TokenType.INTRODUCER,
153            "_LATIN7": TokenType.INTRODUCER,
154            "_MACCE": TokenType.INTRODUCER,
155            "_MACROMAN": TokenType.INTRODUCER,
156            "_SJIS": TokenType.INTRODUCER,
157            "_SWE7": TokenType.INTRODUCER,
158            "_TIS620": TokenType.INTRODUCER,
159            "_UCS2": TokenType.INTRODUCER,
160            "_UJIS": TokenType.INTRODUCER,
161            # https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
162            "_UTF8": TokenType.INTRODUCER,
163            "_UTF16": TokenType.INTRODUCER,
164            "_UTF16LE": TokenType.INTRODUCER,
165            "_UTF32": TokenType.INTRODUCER,
166            "_UTF8MB3": TokenType.INTRODUCER,
167            "_UTF8MB4": TokenType.INTRODUCER,
168            "@@": TokenType.SESSION_PARAMETER,
169        }
170
171        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE} - {TokenType.SHOW}
172
173    Parser = MySQLParser
174
175    Generator = MySQLGenerator
class MySQL(sqlglot.dialects.dialect.Dialect): 
 16class MySQL(Dialect):
 17    PROMOTE_TO_INFERRED_DATETIME_TYPE = True
 18    USING_COLUMN_ORDER = UsingColumnOrder.LEFT_TABLE
 19
 20    # https://dev.mysql.com/doc/refman/8.0/en/identifiers.html
 21    IDENTIFIERS_CAN_START_WITH_DIGIT = True
 22
 23    # We default to treating all identifiers as case-sensitive, since it matches MySQL's
 24    # behavior on Linux systems. For MacOS and Windows systems, one can override this
 25    # setting by specifying `dialect="mysql, normalization_strategy = lowercase"`.
 26    #
 27    # See also https://dev.mysql.com/doc/refman/8.2/en/identifier-case-sensitivity.html
 28    NORMALIZATION_STRATEGY = NormalizationStrategy.CASE_SENSITIVE
 29
 30    TIME_FORMAT = "'%Y-%m-%d %T'"
 31    DPIPE_IS_STRING_CONCAT = False
 32    CONCAT_WS_COALESCE = True
 33    SUPPORTS_USER_DEFINED_TYPES = False
 34    SAFE_DIVISION = True
 35    SAFE_TO_ELIMINATE_DOUBLE_NEGATION = False
 36    LEAST_GREATEST_IGNORES_NULLS = False
 37
 38    EXPRESSION_METADATA = EXPRESSION_METADATA.copy()
 39
 40    # https://prestodb.io/docs/current/functions/datetime.html#mysql-date-functions
 41    TIME_MAPPING = {
 42        "%M": "%B",
 43        "%c": "%-m",
 44        "%e": "%-d",
 45        "%h": "%I",
 46        "%i": "%M",
 47        "%s": "%S",
 48        "%u": "%W",
 49        "%k": "%-H",
 50        "%l": "%-I",
 51        "%r": "%I:%M:%S %p",
 52        "%T": "%H:%M:%S",
 53        "%W": "%A",
 54        "%x": "%G",
 55        # %v (ISO week) is unmapped due to collision with %V (roundtrip issue)
 56    }
 57
 58    VALID_INTERVAL_UNITS = {
 59        *Dialect.VALID_INTERVAL_UNITS,
 60        "SECOND_MICROSECOND",
 61        "MINUTE_MICROSECOND",
 62        "MINUTE_SECOND",
 63        "HOUR_MICROSECOND",
 64        "HOUR_SECOND",
 65        "HOUR_MINUTE",
 66        "DAY_MICROSECOND",
 67        "DAY_SECOND",
 68        "DAY_MINUTE",
 69        "DAY_HOUR",
 70        "YEAR_MONTH",
 71    }
 72
 73    UNESCAPED_SEQUENCES = {
 74        "\\0": "\0",
 75        "\\Z": "\x1a",
 76        "\\%": "\\%",
 77        "\\_": "\\_",
 78        "\\a": "a",
 79        "\\f": "f",
 80        "\\v": "v",
 81    }
 82
 83    class Tokenizer(tokens.Tokenizer):
 84        QUOTES = ["'", '"']
 85        COMMENTS = ["--", "#", ("/*", "*/")]
 86        IDENTIFIERS = ["`"]
 87        STRING_ESCAPES = ["'", '"', "\\"]
 88        BIT_STRINGS = [("b'", "'"), ("B'", "'"), ("0b", "")]
 89        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", "")]
 90        # https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
 91        DROP_UNKNOWN_ESCAPES = True
 92
 93        NESTED_COMMENTS = False
 94        DASH_COMMENT_REQUIRES_BOUNDARY = True
 95        COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
 96
 97        KEYWORDS = {
 98            **tokens.Tokenizer.KEYWORDS,
 99            "BLOB": TokenType.BLOB,
100            "CHARSET": TokenType.CHARACTER_SET,
101            "DISTINCTROW": TokenType.DISTINCT,
102            "EXPLAIN": TokenType.DESCRIBE,
103            "FORCE": TokenType.FORCE,
104            "IGNORE": TokenType.IGNORE,
105            "KEY": TokenType.KEY,
106            "LOCK TABLES": TokenType.COMMAND,
107            "LONGBLOB": TokenType.LONGBLOB,
108            "LONGTEXT": TokenType.LONGTEXT,
109            "MEDIUMBLOB": TokenType.MEDIUMBLOB,
110            "MEDIUMINT": TokenType.MEDIUMINT,
111            "MEDIUMTEXT": TokenType.MEDIUMTEXT,
112            "MEMBER OF": TokenType.MEMBER_OF,
113            "MOD": TokenType.MOD,
114            "SEPARATOR": TokenType.SEPARATOR,
115            "SERIAL": TokenType.SERIAL,
116            "SIGNED": TokenType.BIGINT,
117            "SIGNED INTEGER": TokenType.BIGINT,
118            "START": TokenType.BEGIN,
119            "TIMESTAMP": TokenType.TIMESTAMPTZ,
120            "TINYBLOB": TokenType.TINYBLOB,
121            "TINYTEXT": TokenType.TINYTEXT,
122            "UNLOCK TABLES": TokenType.COMMAND,
123            "UNSIGNED": TokenType.UBIGINT,
124            "UNSIGNED INTEGER": TokenType.UBIGINT,
125            "YEAR": TokenType.YEAR,
126            "_ARMSCII8": TokenType.INTRODUCER,
127            "_ASCII": TokenType.INTRODUCER,
128            "_BIG5": TokenType.INTRODUCER,
129            "_BINARY": TokenType.INTRODUCER,
130            "_CP1250": TokenType.INTRODUCER,
131            "_CP1251": TokenType.INTRODUCER,
132            "_CP1256": TokenType.INTRODUCER,
133            "_CP1257": TokenType.INTRODUCER,
134            "_CP850": TokenType.INTRODUCER,
135            "_CP852": TokenType.INTRODUCER,
136            "_CP866": TokenType.INTRODUCER,
137            "_CP932": TokenType.INTRODUCER,
138            "_DEC8": TokenType.INTRODUCER,
139            "_EUCJPMS": TokenType.INTRODUCER,
140            "_EUCKR": TokenType.INTRODUCER,
141            "_GB18030": TokenType.INTRODUCER,
142            "_GB2312": TokenType.INTRODUCER,
143            "_GBK": TokenType.INTRODUCER,
144            "_GEOSTD8": TokenType.INTRODUCER,
145            "_GREEK": TokenType.INTRODUCER,
146            "_HEBREW": TokenType.INTRODUCER,
147            "_HP8": TokenType.INTRODUCER,
148            "_KEYBCS2": TokenType.INTRODUCER,
149            "_KOI8R": TokenType.INTRODUCER,
150            "_KOI8U": TokenType.INTRODUCER,
151            "_LATIN1": TokenType.INTRODUCER,
152            "_LATIN2": TokenType.INTRODUCER,
153            "_LATIN5": TokenType.INTRODUCER,
154            "_LATIN7": TokenType.INTRODUCER,
155            "_MACCE": TokenType.INTRODUCER,
156            "_MACROMAN": TokenType.INTRODUCER,
157            "_SJIS": TokenType.INTRODUCER,
158            "_SWE7": TokenType.INTRODUCER,
159            "_TIS620": TokenType.INTRODUCER,
160            "_UCS2": TokenType.INTRODUCER,
161            "_UJIS": TokenType.INTRODUCER,
162            # https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
163            "_UTF8": TokenType.INTRODUCER,
164            "_UTF16": TokenType.INTRODUCER,
165            "_UTF16LE": TokenType.INTRODUCER,
166            "_UTF32": TokenType.INTRODUCER,
167            "_UTF8MB3": TokenType.INTRODUCER,
168            "_UTF8MB4": TokenType.INTRODUCER,
169            "@@": TokenType.SESSION_PARAMETER,
170        }
171
172        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE} - {TokenType.SHOW}
173
174    Parser = MySQLParser
175
176    Generator = MySQLGenerator
PROMOTE_TO_INFERRED_DATETIME_TYPE = True

This flag is used in the optimizer's canonicalize rule and determines whether x will be promoted to the literal's type in x::DATE < '2020-01-01 12:05:03' (i.e., DATETIME). When false, the literal is cast to x's type to match it instead.

USING_COLUMN_ORDER = <UsingColumnOrder.LEFT_TABLE: 'LEFT_TABLE'>

Where star expansion places the columns of a USING or NATURAL join.

Given a(a_id, k1, k2) and b(k2, b_id, k1), SELECT * FROM a JOIN b USING (k2, k1) returns:

  • USING_LIST: k2, k1, a_id, b_id
  • LEFT_TABLE: k1, k2, a_id, b_id
  • IN_PLACE: a_id, k1, k2, b_id

When join columns come first, this applies at every join: each USING join moves its columns ahead of all the columns to its left.

IDENTIFIERS_CAN_START_WITH_DIGIT = True

Whether an unquoted identifier can start with a digit.

NORMALIZATION_STRATEGY = <NormalizationStrategy.CASE_SENSITIVE: 'CASE_SENSITIVE'>

Specifies the strategy according to which identifiers should be normalized.

TIME_FORMAT = "'%Y-%m-%d %T'"
DPIPE_IS_STRING_CONCAT = False

Whether the DPIPE token (||) is a string concatenation operator.

CONCAT_WS_COALESCE = True

A NULL arg in CONCAT_WS yields NULL by default, but in some dialects it is skipped.

SUPPORTS_USER_DEFINED_TYPES = False

Whether user-defined data types are supported.

SAFE_DIVISION = True

Whether division by zero throws an error (False) or returns NULL (True).

SAFE_TO_ELIMINATE_DOUBLE_NEGATION = False
LEAST_GREATEST_IGNORES_NULLS = False

Whether LEAST/GREATEST functions ignore NULL values, e.g:

  • BigQuery, Snowflake, MySQL, Presto/Trino: LEAST(1, NULL, 2) -> NULL
  • Spark, Postgres, DuckDB, TSQL: LEAST(1, NULL, 2) -> 1
EXPRESSION_METADATA = {<class 'sqlglot.expressions.core.Add'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Adjacent'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.And'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayContainedBy'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayContains'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayContainsAll'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayOverlaps'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayPosition'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Binary'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseAnd'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseLeftShift'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseOr'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseRightShift'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseXor'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.Collate'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Connector'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.Corr'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.DPipe'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.core.Distance'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.DistanceNd'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Div'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.Dot'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.EQ'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Escape'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.ExtendsLeft'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.ExtendsRight'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.GT'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.GTE'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Glob'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.ILike'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.IntDiv'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Is'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONArrayContains'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBContains'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBContainsAllTopKeys'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBContainsAnyTopKeys'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBContainsTopKey'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBDeleteAtPath'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBExtract'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBExtractScalar'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONBPathExists'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.json.JSONExtract'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONExtractScalar'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Kwarg'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.LT'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.LTE'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Like'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Match'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Mod'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Mul'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.NEQ'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.NestedJSONSelect'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.NullSafeEQ'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.NullSafeNEQ'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Operator'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Or'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Overlaps'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Pow'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.core.PropertyEQ'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.string.RegexpFullMatch'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.string.RegexpILike'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.RegexpLike'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.SimilarTo'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Sub'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Xor'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Alias'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.BitwiseNot'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.IgnoreNulls'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Neg'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Not'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Paren'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.PivotAlias'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.RespectNulls'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Unary'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.CountIf'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.functions.Int64'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.aggregate.Rank'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.core.ApproxDistinct'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.aggregate.RowNumber'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.aggregate.DenseRank'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.temporal.UnixSeconds'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.aggregate.Ntile'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.temporal.UnixMillis'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.temporal.UnixMicros'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.array.ArraySize'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.string.FromBase64'>: {'returns': <DType.BINARY: 'BINARY'>}, <class 'sqlglot.expressions.string.FromBase32'>: {'returns': <DType.BINARY: 'BINARY'>}, <class 'sqlglot.expressions.string.EndsWith'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.core.Any'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.aggregate.LogicalAnd'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.string.Contains'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.core.All'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.core.Boolean'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.functions.Exists'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.math.IsNan'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.core.In'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.string.StartsWith'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.aggregate.LogicalOr'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.core.Between'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.math.IsInf'>: {'returns': <DType.BOOLEAN: 'BOOLEAN'>}, <class 'sqlglot.expressions.temporal.LastDay'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.TimeStrToDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.DateFromParts'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.DiToDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.TsOrDsToDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.Date'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.StrToDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.DateStrToDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.CurrentDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.temporal.DatetimeAdd'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.CurrentDatetime'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.DatetimeSub'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.Datetime'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.math.Log'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.StddevSamp'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Variance'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Cot'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Kurtosis'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Quantile'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Skewness'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.string.ToDouble'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Tan'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.CumeDist'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.CovarPop'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Sin'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Sqrt'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Atan'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Avg'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Degrees'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Exp'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Round'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Asin'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Pi'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.functions.Rand'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Cbrt'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Acos'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.VariancePop'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.ApproxQuantile'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Ln'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.Stddev'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.StddevPop'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Cosh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.PercentRank'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Tanh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.PercentileCont'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.aggregate.CovarSamp'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.SafeDivide'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Sinh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Cos'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Atanh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Radians'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Asinh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Acosh'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.temporal.DatetimeDiff'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.DayOfMonth'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.Quarter'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.DateToDi'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.StrPosition'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.Hour'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.Length'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.DayOfYear'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.TimestampDiff'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.DayOfWeek'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.UnixDate'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.math.Getbit'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.Ascii'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.TsOrDiToDi'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.Levenshtein'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.math.Sign'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.Unicode'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.TimeDiff'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.string.BitLength'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.MakeInterval'>: {'returns': <DType.INTERVAL: 'INTERVAL'>}, <class 'sqlglot.expressions.temporal.JustifyInterval'>: {'returns': <DType.INTERVAL: 'INTERVAL'>}, <class 'sqlglot.expressions.temporal.JustifyHours'>: {'returns': <DType.INTERVAL: 'INTERVAL'>}, <class 'sqlglot.expressions.temporal.JustifyDays'>: {'returns': <DType.INTERVAL: 'INTERVAL'>}, <class 'sqlglot.expressions.datatypes.Interval'>: {'returns': <DType.INTERVAL: 'INTERVAL'>}, <class 'sqlglot.expressions.json.ParseJSON'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.temporal.Time'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.temporal.Localtime'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.TimeSub'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.temporal.TimeAdd'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.temporal.CurrentTime'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.temporal.TimestampLtzFromParts'>: {'returns': <DType.TIMESTAMPLTZ: 'TIMESTAMPLTZ'>}, <class 'sqlglot.expressions.temporal.TimestampTzFromParts'>: {'returns': <DType.TIMESTAMPTZ: 'TIMESTAMPTZ'>}, <class 'sqlglot.expressions.temporal.CurrentTimestampLTZ'>: {'returns': <DType.TIMESTAMPTZ: 'TIMESTAMPTZ'>}, <class 'sqlglot.expressions.temporal.TimeStrToTime'>: {'returns': <DType.TIMESTAMP: 'TIMESTAMP'>}, <class 'sqlglot.expressions.temporal.UnixToTime'>: {'returns': <DType.TIMESTAMP: 'TIMESTAMP'>}, <class 'sqlglot.expressions.temporal.TimestampSub'>: {'returns': <DType.TIMESTAMP: 'TIMESTAMP'>}, <class 'sqlglot.expressions.temporal.StrToTime'>: {'returns': <DType.TIMESTAMP: 'TIMESTAMP'>}, <class 'sqlglot.expressions.temporal.CurrentTimestamp'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.TimestampAdd'>: {'returns': <DType.TIMESTAMP: 'TIMESTAMP'>}, <class 'sqlglot.expressions.temporal.YearOfWeekIso'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.temporal.WeekOfYear'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.temporal.Week'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.Day'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.temporal.YearOfWeek'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.temporal.DayOfWeekIso'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.temporal.Month'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.Year'>: {'returns': <DType.TINYINT: 'TINYINT'>}, <class 'sqlglot.expressions.string.Translate'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Substring'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.String'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.CurrentSchema'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.array.ArrayToString'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.query.RawString'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.CurrentRole'>: {'returns': <DType.LONGTEXT: 'LONGTEXT'>}, <class 'sqlglot.expressions.string.Lower'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.TimeToStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.ToBase32'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.core.Typeof'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Upper'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.UnixToStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Concat'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Repeat'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Trim'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.UnixToTimeStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.TsOrDsToDateStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.SHA2'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.Monthname'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.DateToDateStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.SHA'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.TimeToTimeStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.ToBase64'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.aggregate.GroupConcat'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.SessionUser'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.ConcatWs'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.MD5'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Space'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.Dayname'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.CurrentVersion'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Initcap'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Chr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.CurrentCatalog'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.CurrentUser'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.math.Floor'>: {'annotator': <function annotate_by_numeric_arg>}, <class 'sqlglot.expressions.math.Ceil'>: {'annotator': <function annotate_by_numeric_arg>}, <class 'sqlglot.expressions.aggregate.AnyValue'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.NthValue'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.SortArray'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.query.Limit'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.LastValue'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Filter'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.FirstValue'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.HavingMax'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArraySlice'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayReverse'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.query.Order'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.query.Window'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.ArrayConcatAgg'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.math.Abs'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayConcat'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.Least'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.Min'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.Greatest'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.Coalesce'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.Max'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayLast'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.ArrayFirst'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Anonymous'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.DateSub'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.temporal.DateTrunc'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.temporal.DateAdd'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.Cast'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.functions.TryCast'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.Map'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.VarMap'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.array.Array'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.aggregate.ArrayAgg'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.Bracket'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.functions.Case'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.aggregate.Count'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.DateDiff'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.datatypes.DataType'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.Distinct'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.array.Explode'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.Extract'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.query.HexString'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.array.GenerateSeries'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.GenerateDateArray'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.GenerateTimestampArray'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.functions.If'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.aggregate.Lag'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.aggregate.Lead'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.core.Literal'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.Null'>: {'returns': <DType.NULL: 'NULL'>}, <class 'sqlglot.expressions.functions.Nullif'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.array.Struct'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.aggregate.Sum'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.temporal.Timestamp'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.array.ToMap'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.array.Unnest'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.core.WithinGroup'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.query.Subquery'>: {'annotator': <function <lambda>>}, <class 'sqlglot.expressions.string.MatchAgainst'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.math.Atan2'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.array.StDistance'>: {'returns': <DType.DOUBLE: 'DOUBLE'>}, <class 'sqlglot.expressions.temporal.Localtimestamp'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.ConvertTimezone'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.UtcTimestamp'>: {'returns': <DType.DATETIME: 'DATETIME'>}, <class 'sqlglot.expressions.temporal.UtcDate'>: {'returns': <DType.DATE: 'DATE'>}, <class 'sqlglot.expressions.string.Replace'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Elt'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.SubstringIndex'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Stuff'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.NumberToStr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.Hex'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.string.RegexpSubstr'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.Collation'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.functions.Uuid'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.json.JSONType'>: {'returns': <DType.VARCHAR: 'VARCHAR'>}, <class 'sqlglot.expressions.temporal.Minute'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.temporal.Second'>: {'returns': <DType.INT: 'INT'>}, <class 'sqlglot.expressions.aggregate.Grouping'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.string.RegexpInstr'>: {'returns': <DType.BIGINT: 'BIGINT'>}, <class 'sqlglot.expressions.temporal.TimeFromParts'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.temporal.UtcTime'>: {'returns': <DType.TIME: 'TIME'>}, <class 'sqlglot.expressions.string.Unhex'>: {'returns': <DType.VARBINARY: 'VARBINARY'>}, <class 'sqlglot.expressions.json.JSONRemove'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONObjectAgg'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONObject'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONKeys'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONArrayInsert'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONArrayAppend'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.json.JSONSet'>: {'returns': <DType.JSON: 'JSON'>}, <class 'sqlglot.expressions.string.Left'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.string.Pad'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.string.Right'>: {'annotator': <function <dictcomp>.<lambda>>}, <class 'sqlglot.expressions.math.BitwiseAndAgg'>: {'annotator': <function _annotate_bit_func>}, <class 'sqlglot.expressions.math.BitwiseOrAgg'>: {'annotator': <function _annotate_bit_func>}, <class 'sqlglot.expressions.math.BitwiseXorAgg'>: {'annotator': <function _annotate_bit_func>}, <class 'sqlglot.expressions.string.Reverse'>: {'annotator': <function _annotate_reverse>}, <class 'sqlglot.expressions.math.Trunc'>: {'annotator': <function _annotate_truncate>}, <class 'sqlglot.expressions.string.RegexpReplace'>: {'annotator': <function _annotate_regexp_replace>}, <class 'sqlglot.expressions.string.Compress'>: {'annotator': <function _annotate_compress>}}
TIME_MAPPING: dict[str, str] = {'%M': '%B', '%c': '%-m', '%e': '%-d', '%h': '%I', '%i': '%M', '%s': '%S', '%u': '%W', '%k': '%-H', '%l': '%-I', '%r': '%I:%M:%S %p', '%T': '%H:%M:%S', '%W': '%A', '%x': '%G'}

Associates this dialect's time formats with their equivalent Python strftime formats.

VALID_INTERVAL_UNITS: set[str] = {'YR', 'WK', 'NSECOND', 'MI', 'QUARTER', 'CENTS', 'WOY', 'SECS', 'DAYOFWEEK_ISO', 'MINS', 'MM', 'MILLENIA', 'Y', 'DAYOFMONTH', 'HR', 'YYYY', 'MONS', 'TZM', 'MICROSECOND', 'EPOCH_SECOND', 'YEARS', 'HOUR_MICROSECOND', 'MICROSECONDS', 'WEEKOFYEAR_ISO', 'MICROSEC', 'US', 'H', 'M', 'DW_ISO', 'HH', 'DAYOFWEEK', 'USECOND', 'DEC', 'C', 'MILS', 'DAYOFYEAR', 'DAY_SECOND', 'DECS', 'DAY_MINUTE', 'WEEK_ISO', 'DD', 'TIMEZONE_MINUTE', 'DAY_MICROSECOND', 'MON', 'MIL', 'MSECOND', 'USECS', 'SEC', 'YYY', 'MINUTE_MICROSECOND', 'QUARTERS', 'EPOCH_MILLISECOND', 'DAY', 'W', 'MONTH', 'DW', 'DAY_HOUR', 'HOUR', 'MILLENNIUM', 'NANOSECS', 'HOUR_MINUTE', 'MONTHS', 'NSECONDS', 'TIMEZONE_HOUR', 'YY', 'DY', 'DAY OF YEAR', 'NS', 'MICROSECS', 'EPOCH_MILLISECONDS', 'HOURS', 'MIN', 'NANOSEC', 'MILLISECS', 'EPOCH_MICROSECONDS', 'Q', 'USEC', 'NANOSECOND', 'EPOCH', 'CENTURIES', 'EPOCH_SECONDS', 'HRS', 'MILLISECONDS', 'QTRS', 'TZH', 'MS', 'MINUTES', 'WEEKDAY_ISO', 'YEAR', 'WEEK', 'MSECS', 'EPOCH_NANOSECOND', 'MSEC', 'DOW_ISO', 'MINUTE', 'WY', 'NSEC', 'CENTURY', 'DAYS', 'S', 'MILLISEC', 'YRS', 'QTR', 'SECOND_MICROSECOND', 'WEEKOFYEAR', 'YEAR_MONTH', 'DOW', 'MILLISECON', 'DAY OF WEEK', 'SECOND', 'D', 'HOUR_SECOND', 'USECONDS', 'WEEKISO', 'DECADE', 'DAYOFWEEKISO', 'WEEKDAY', 'CENT', 'WEEKOFYEARISO', 'MINUTE_SECOND', 'SECONDS', 'EPOCH_MICROSECOND', 'EPOCH_NANOSECONDS', 'MSECONDS', 'DOY', 'MILLISECOND', 'DECADES'}
UNESCAPED_SEQUENCES: dict[str, str] = {'\\a': 'a', '\\b': '\x08', '\\f': 'f', '\\n': '\n', '\\r': '\r', '\\t': '\t', '\\v': 'v', '\\\\': '\\', '\\0': '\x00', '\\Z': '\x1a', '\\%': '\\%', '\\_': '\\_'}

Mapping of an escaped sequence (\n) to its unescaped version ( ).

SUPPORTS_COLUMN_JOIN_MARKS = False

Whether the old-style outer join (+) syntax is supported.

STRINGS_SUPPORT_ESCAPED_SEQUENCES: bool = True

Whether string literals support escape sequences (e.g. \n). Set by the metaclass based on the tokenizer's STRING_ESCAPES.

BYTE_STRINGS_SUPPORT_ESCAPED_SEQUENCES: bool = True

Whether byte string literals support escape sequences. Set by the metaclass based on the tokenizer's BYTE_STRING_ESCAPES.

IDENTIFIER_ESCAPED_SEQUENCES: dict[str, str] = {}

Mapping of an identifier escape char (\) to its escaped version (\\). Set by the metaclass based on the tokenizer's IDENTIFIER_ESCAPES.

INITCAP_SUPPORTS_CUSTOM_DELIMITERS = False
tokenizer_class = <class 'MySQL.Tokenizer'>
jsonpath_tokenizer_class = <class 'sqlglot.dialects.dialect.JSONPathTokenizer'>
parser_class = <class 'sqlglot.parsers.mysql.MySQLParser'>
generator_class = <class 'sqlglot.generators.mysql.MySQLGenerator'>
TIME_TRIE: dict = {'%': {'M': {0: True}, 'c': {0: True}, 'e': {0: True}, 'h': {0: True}, 'i': {0: True}, 's': {0: True}, 'u': {0: True}, 'k': {0: True}, 'l': {0: True}, 'r': {0: True}, 'T': {0: True}, 'W': {0: True}, 'x': {0: True}}}
FORMAT_TRIE: dict = {'%': {'M': {0: True}, 'c': {0: True}, 'e': {0: True}, 'h': {0: True}, 'i': {0: True}, 's': {0: True}, 'u': {0: True}, 'k': {0: True}, 'l': {0: True}, 'r': {0: True}, 'T': {0: True}, 'W': {0: True}, 'x': {0: True}}}
INVERSE_TIME_MAPPING: dict[str, str] = {'%B': '%M', '%-m': '%c', '%-d': '%e', '%I': '%h', '%M': '%i', '%S': '%s', '%W': '%u', '%-H': '%k', '%-I': '%l', '%I:%M:%S %p': '%r', '%H:%M:%S': '%T', '%A': '%W', '%G': '%x', '%mstrict': '%m', '%dstrict': '%d', '%Hstrict': '%H', '%Istrict': '%h', '%Mstrict': '%i', '%Sstrict': '%s'}
INVERSE_TIME_TRIE: dict = {'%': {'B': {0: True}, '-': {'m': {0: True}, 'd': {0: True}, 'H': {0: True}, 'I': {0: True}}, 'I': {0: True, ':': {'%': {'M': {':': {'%': {'S': {' ': {'%': {'p': {0: True}}}}}}}}}, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'M': {0: True, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'S': {0: True, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'W': {0: True}, 'H': {':': {'%': {'M': {':': {'%': {'S': {0: True}}}}}}, 's': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'A': {0: True}, 'G': {0: True}, 'm': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'd': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}}}
INVERSE_FORMAT_MAPPING: dict[str, str] = {'%mstrict': '%m', '%dstrict': '%d', '%Hstrict': '%H', '%Istrict': '%I', '%Mstrict': '%M', '%Sstrict': '%S'}
INVERSE_FORMAT_TRIE: dict = {'%': {'m': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'd': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'H': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'I': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'M': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}, 'S': {'s': {'t': {'r': {'i': {'c': {'t': {0: True}}}}}}}}}
INVERSE_CREATABLE_KIND_MAPPING: dict[str, str] = {}
ESCAPED_SEQUENCES: dict[str, str] = {'\x08': '\\b', '\n': '\\n', '\r': '\\r', '\t': '\\t', '\\': '\\\\', '\x00': '\\0', '\x1a': '\\Z'}
QUOTE_START = "'"
QUOTE_END = "'"
IDENTIFIER_START = '`'
IDENTIFIER_END = '`'
BIT_START: str | None = "b'"
BIT_END: str | None = "'"
HEX_START: str | None = "x'"
HEX_END: str | None = "'"
BYTE_START: str | None = None
BYTE_END: str | None = None
UNICODE_START: str | None = None
UNICODE_END: str | None = None
class MySQL.Tokenizer(sqlglot.tokens.Tokenizer): 
 83    class Tokenizer(tokens.Tokenizer):
 84        QUOTES = ["'", '"']
 85        COMMENTS = ["--", "#", ("/*", "*/")]
 86        IDENTIFIERS = ["`"]
 87        STRING_ESCAPES = ["'", '"', "\\"]
 88        BIT_STRINGS = [("b'", "'"), ("B'", "'"), ("0b", "")]
 89        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", "")]
 90        # https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
 91        DROP_UNKNOWN_ESCAPES = True
 92
 93        NESTED_COMMENTS = False
 94        DASH_COMMENT_REQUIRES_BOUNDARY = True
 95        COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
 96
 97        KEYWORDS = {
 98            **tokens.Tokenizer.KEYWORDS,
 99            "BLOB": TokenType.BLOB,
100            "CHARSET": TokenType.CHARACTER_SET,
101            "DISTINCTROW": TokenType.DISTINCT,
102            "EXPLAIN": TokenType.DESCRIBE,
103            "FORCE": TokenType.FORCE,
104            "IGNORE": TokenType.IGNORE,
105            "KEY": TokenType.KEY,
106            "LOCK TABLES": TokenType.COMMAND,
107            "LONGBLOB": TokenType.LONGBLOB,
108            "LONGTEXT": TokenType.LONGTEXT,
109            "MEDIUMBLOB": TokenType.MEDIUMBLOB,
110            "MEDIUMINT": TokenType.MEDIUMINT,
111            "MEDIUMTEXT": TokenType.MEDIUMTEXT,
112            "MEMBER OF": TokenType.MEMBER_OF,
113            "MOD": TokenType.MOD,
114            "SEPARATOR": TokenType.SEPARATOR,
115            "SERIAL": TokenType.SERIAL,
116            "SIGNED": TokenType.BIGINT,
117            "SIGNED INTEGER": TokenType.BIGINT,
118            "START": TokenType.BEGIN,
119            "TIMESTAMP": TokenType.TIMESTAMPTZ,
120            "TINYBLOB": TokenType.TINYBLOB,
121            "TINYTEXT": TokenType.TINYTEXT,
122            "UNLOCK TABLES": TokenType.COMMAND,
123            "UNSIGNED": TokenType.UBIGINT,
124            "UNSIGNED INTEGER": TokenType.UBIGINT,
125            "YEAR": TokenType.YEAR,
126            "_ARMSCII8": TokenType.INTRODUCER,
127            "_ASCII": TokenType.INTRODUCER,
128            "_BIG5": TokenType.INTRODUCER,
129            "_BINARY": TokenType.INTRODUCER,
130            "_CP1250": TokenType.INTRODUCER,
131            "_CP1251": TokenType.INTRODUCER,
132            "_CP1256": TokenType.INTRODUCER,
133            "_CP1257": TokenType.INTRODUCER,
134            "_CP850": TokenType.INTRODUCER,
135            "_CP852": TokenType.INTRODUCER,
136            "_CP866": TokenType.INTRODUCER,
137            "_CP932": TokenType.INTRODUCER,
138            "_DEC8": TokenType.INTRODUCER,
139            "_EUCJPMS": TokenType.INTRODUCER,
140            "_EUCKR": TokenType.INTRODUCER,
141            "_GB18030": TokenType.INTRODUCER,
142            "_GB2312": TokenType.INTRODUCER,
143            "_GBK": TokenType.INTRODUCER,
144            "_GEOSTD8": TokenType.INTRODUCER,
145            "_GREEK": TokenType.INTRODUCER,
146            "_HEBREW": TokenType.INTRODUCER,
147            "_HP8": TokenType.INTRODUCER,
148            "_KEYBCS2": TokenType.INTRODUCER,
149            "_KOI8R": TokenType.INTRODUCER,
150            "_KOI8U": TokenType.INTRODUCER,
151            "_LATIN1": TokenType.INTRODUCER,
152            "_LATIN2": TokenType.INTRODUCER,
153            "_LATIN5": TokenType.INTRODUCER,
154            "_LATIN7": TokenType.INTRODUCER,
155            "_MACCE": TokenType.INTRODUCER,
156            "_MACROMAN": TokenType.INTRODUCER,
157            "_SJIS": TokenType.INTRODUCER,
158            "_SWE7": TokenType.INTRODUCER,
159            "_TIS620": TokenType.INTRODUCER,
160            "_UCS2": TokenType.INTRODUCER,
161            "_UJIS": TokenType.INTRODUCER,
162            # https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
163            "_UTF8": TokenType.INTRODUCER,
164            "_UTF16": TokenType.INTRODUCER,
165            "_UTF16LE": TokenType.INTRODUCER,
166            "_UTF32": TokenType.INTRODUCER,
167            "_UTF8MB3": TokenType.INTRODUCER,
168            "_UTF8MB4": TokenType.INTRODUCER,
169            "@@": TokenType.SESSION_PARAMETER,
170        }
171
172        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE} - {TokenType.SHOW}
QUOTES = ["'", '"']
COMMENTS = ['--', '#', ('/*', '*/')]
IDENTIFIERS = ['`']
STRING_ESCAPES = ["'", '"', '\\']
BIT_STRINGS = [("b'", "'"), ("B'", "'"), ('0b', '')]
HEX_STRINGS = [("x'", "'"), ("X'", "'"), ('0x', '')]
DROP_UNKNOWN_ESCAPES = True
NESTED_COMMENTS = False
DASH_COMMENT_REQUIRES_BOUNDARY = True
COMMENTS_TERMINATE_AT_NEWLINE_ONLY = True
KEYWORDS = {'{%': <TokenType.BLOCK_START: 73>, '{%+': <TokenType.BLOCK_START: 73>, '{%-': <TokenType.BLOCK_START: 73>, '%}': <TokenType.BLOCK_END: 74>, '+%}': <TokenType.BLOCK_END: 74>, '-%}': <TokenType.BLOCK_END: 74>, '{{+': <TokenType.BLOCK_START: 73>, '{{-': <TokenType.BLOCK_START: 73>, '+}}': <TokenType.BLOCK_END: 74>, '-}}': <TokenType.BLOCK_END: 74>, '/*+': <TokenType.HINT: 293>, '&<': <TokenType.AMP_LT: 63>, '&>': <TokenType.AMP_GT: 64>, '==': <TokenType.EQ: 28>, '::': <TokenType.DCOLON: 14>, '?::': <TokenType.QDCOLON: 370>, '||': <TokenType.DPIPE: 37>, '|>': <TokenType.PIPE_GT: 38>, '>=': <TokenType.GTE: 26>, '<=': <TokenType.LTE: 24>, '<>': <TokenType.NEQ: 29>, '!=': <TokenType.NEQ: 29>, ':=': <TokenType.COLON_EQ: 31>, '<=>': <TokenType.NULLSAFE_EQ: 30>, '->': <TokenType.ARROW: 45>, '->>': <TokenType.DARROW: 46>, '=>': <TokenType.FARROW: 47>, '#>': <TokenType.HASH_ARROW: 49>, '#>>': <TokenType.DHASH_ARROW: 50>, '<->': <TokenType.LR_ARROW: 51>, '<<->>': <TokenType.LLRR_ARROW: 52>, '&&': <TokenType.DAMP: 62>, '??': <TokenType.DQMARK: 18>, '~~~': <TokenType.GLOB: 287>, '~~': <TokenType.LIKE: 318>, '~~*': <TokenType.ILIKE: 295>, '~*': <TokenType.IRLIKE: 307>, '-|-': <TokenType.ADJACENT: 65>, 'ALL': <TokenType.ALL: 220>, 'AND': <TokenType.AND: 34>, 'ANTI': <TokenType.ANTI: 221>, 'ANY': <TokenType.ANY: 222>, 'ASC': <TokenType.ASC: 225>, 'AS': <TokenType.ALIAS: 218>, 'ASOF': <TokenType.ASOF: 226>, 'AUTOINCREMENT': <TokenType.AUTO_INCREMENT: 228>, 'AUTO_INCREMENT': <TokenType.AUTO_INCREMENT: 228>, 'BEGIN': <TokenType.BEGIN: 229>, 'BETWEEN': <TokenType.BETWEEN: 230>, 'CACHE': <TokenType.CACHE: 232>, 'UNCACHE': <TokenType.UNCACHE: 414>, 'CASE': <TokenType.CASE: 233>, 'CLUSTER BY': <TokenType.CLUSTER_BY: 235>, 'COLLATE': <TokenType.COLLATE: 236>, 'COLUMN': <TokenType.COLUMN: 81>, 'COMMIT': <TokenType.COMMIT: 239>, 'CONNECT BY': <TokenType.CONNECT_BY: 240>, 'CONSTRAINT': <TokenType.CONSTRAINT: 241>, 'COPY': <TokenType.COPY: 242>, 'CREATE': <TokenType.CREATE: 243>, 'CROSS': <TokenType.CROSS: 244>, 'CUBE': <TokenType.CUBE: 245>, 'CURRENT_DATE': <TokenType.CURRENT_DATE: 246>, 'CURRENT_SCHEMA': <TokenType.CURRENT_SCHEMA: 248>, 'CURRENT_TIME': <TokenType.CURRENT_TIME: 249>, 'CURRENT_TIMESTAMP': <TokenType.CURRENT_TIMESTAMP: 250>, 'CURRENT_USER': <TokenType.CURRENT_USER: 251>, 'CURRENT_CATALOG': <TokenType.CURRENT_CATALOG: 254>, 'DATABASE': <TokenType.DATABASE: 80>, 'DEFAULT': <TokenType.DEFAULT: 256>, 'DELETE': <TokenType.DELETE: 257>, 'DESC': <TokenType.DESC: 258>, 'DESCRIBE': <TokenType.DESCRIBE: 259>, 'DISTINCT': <TokenType.DISTINCT: 262>, 'DISTRIBUTE BY': <TokenType.DISTRIBUTE_BY: 263>, 'DIV': <TokenType.DIV: 264>, 'DROP': <TokenType.DROP: 265>, 'ELSE': <TokenType.ELSE: 266>, 'END': <TokenType.END: 267>, 'ENUM': <TokenType.ENUM: 205>, 'ESCAPE': <TokenType.ESCAPE: 268>, 'EXCEPT': <TokenType.EXCEPT: 269>, 'EXECUTE': <TokenType.EXECUTE: 270>, 'EXISTS': <TokenType.EXISTS: 271>, 'FALSE': <TokenType.FALSE: 272>, 'FETCH': <TokenType.FETCH: 273>, 'FILTER': <TokenType.FILTER: 276>, 'FILE': <TokenType.FILE: 274>, 'FIRST': <TokenType.FIRST: 278>, 'FULL': <TokenType.FULL: 284>, 'FUNCTION': <TokenType.FUNCTION: 285>, 'FOR': <TokenType.FOR: 279>, 'FOREIGN KEY': <TokenType.FOREIGN_KEY: 281>, 'FORMAT': <TokenType.FORMAT: 282>, 'FROM': <TokenType.FROM: 283>, 'GEOGRAPHY': <TokenType.GEOGRAPHY: 172>, 'GEOMETRY': <TokenType.GEOMETRY: 175>, 'GLOB': <TokenType.GLOB: 287>, 'GROUP BY': <TokenType.GROUP_BY: 290>, 'GROUPING SETS': <TokenType.GROUPING_SETS: 291>, 'HAVING': <TokenType.HAVING: 292>, 'ILIKE': <TokenType.ILIKE: 295>, 'IN': <TokenType.IN: 296>, 'INDEX': <TokenType.INDEX: 297>, 'INET': <TokenType.INET: 200>, 'INNER': <TokenType.INNER: 299>, 'INSERT': <TokenType.INSERT: 300>, 'INTERVAL': <TokenType.INTERVAL: 304>, 'INTERSECT': <TokenType.INTERSECT: 303>, 'INTO': <TokenType.INTO: 305>, 'IS': <TokenType.IS: 308>, 'ISNULL': <TokenType.ISNULL: 309>, 'JOIN': <TokenType.JOIN: 310>, 'KEEP': <TokenType.KEEP: 312>, 'KILL': <TokenType.KILL: 314>, 'LATERAL': <TokenType.LATERAL: 316>, 'LEFT': <TokenType.LEFT: 317>, 'LIKE': <TokenType.LIKE: 318>, 'LIMIT': <TokenType.LIMIT: 319>, 'LOAD': <TokenType.LOAD: 321>, 'LOCALTIME': <TokenType.LOCALTIME: 179>, 'LOCALTIMESTAMP': <TokenType.LOCALTIMESTAMP: 180>, 'LOCK': <TokenType.LOCK: 322>, 'MERGE': <TokenType.MERGE: 328>, 'NAMESPACE': <TokenType.NAMESPACE: 440>, 'NATURAL': <TokenType.NATURAL: 331>, 'NEXT': <TokenType.NEXT: 332>, 'NOT': <TokenType.NOT: 27>, 'NOTNULL': <TokenType.NOTNULL: 334>, 'NULL': <TokenType.NULL: 335>, 'OBJECT': <TokenType.OBJECT: 199>, 'OFFSET': <TokenType.OFFSET: 337>, 'ON': <TokenType.ON: 338>, 'OR': <TokenType.OR: 35>, 'XOR': <TokenType.XOR: 66>, 'ORDER BY': <TokenType.ORDER_BY: 341>, 'ORDINALITY': <TokenType.ORDINALITY: 344>, 'OUT': <TokenType.OUT: 345>, 'OUTER': <TokenType.OUTER: 347>, 'OVER': <TokenType.OVER: 348>, 'OVERLAPS': <TokenType.OVERLAPS: 349>, 'OVERWRITE': <TokenType.OVERWRITE: 350>, 'PARTITION': <TokenType.PARTITION: 352>, 'PARTITION BY': <TokenType.PARTITION_BY: 353>, 'PARTITIONED BY': <TokenType.PARTITION_BY: 353>, 'PARTITIONED_BY': <TokenType.PARTITION_BY: 353>, 'PERCENT': <TokenType.PERCENT: 354>, 'PIVOT': <TokenType.PIVOT: 355>, 'PRAGMA': <TokenType.PRAGMA: 360>, 'PRIMARY KEY': <TokenType.PRIMARY_KEY: 362>, 'PROCEDURE': <TokenType.PROCEDURE: 363>, 'OPERATOR': <TokenType.OPERATOR: 340>, 'QUALIFY': <TokenType.QUALIFY: 368>, 'RANGE': <TokenType.RANGE: 371>, 'RECURSIVE': <TokenType.RECURSIVE: 372>, 'REGEXP': <TokenType.RLIKE: 380>, 'RENAME': <TokenType.RENAME: 374>, 'REPLACE': <TokenType.REPLACE: 375>, 'RETURNING': <TokenType.RETURNING: 376>, 'REFERENCES': <TokenType.REFERENCES: 378>, 'RIGHT': <TokenType.RIGHT: 379>, 'RLIKE': <TokenType.RLIKE: 380>, 'ROLLBACK': <TokenType.ROLLBACK: 382>, 'ROLLUP': <TokenType.ROLLUP: 383>, 'ROW': <TokenType.ROW: 384>, 'ROWS': <TokenType.ROWS: 385>, 'SCHEMA': <TokenType.SCHEMA: 83>, 'SELECT': <TokenType.SELECT: 387>, 'SEMI': <TokenType.SEMI: 388>, 'SESSION': <TokenType.SESSION: 59>, 'SESSION_USER': <TokenType.SESSION_USER: 61>, 'SET': <TokenType.SET: 392>, 'SETTINGS': <TokenType.SETTINGS: 393>, 'SHOW': <TokenType.SHOW: 394>, 'SIMILAR TO': <TokenType.SIMILAR_TO: 395>, 'SOME': <TokenType.SOME: 396>, 'SORT BY': <TokenType.SORT_BY: 397>, 'SQL SECURITY': <TokenType.SQL_SECURITY: 399>, 'STRAIGHT_JOIN': <TokenType.STRAIGHT_JOIN: 402>, 'TABLE': <TokenType.TABLE: 84>, 'TABLESAMPLE': <TokenType.TABLE_SAMPLE: 405>, 'TEMP': <TokenType.TEMPORARY: 407>, 'TEMPORARY': <TokenType.TEMPORARY: 407>, 'THEN': <TokenType.THEN: 409>, 'TRUE': <TokenType.TRUE: 410>, 'TRUNCATE': <TokenType.TRUNCATE: 411>, 'TRIGGER': <TokenType.TRIGGER: 412>, 'UNION': <TokenType.UNION: 416>, 'UNKNOWN': <TokenType.UNKNOWN: 214>, 'UNNEST': <TokenType.UNNEST: 417>, 'UNPIVOT': <TokenType.UNPIVOT: 418>, 'UPDATE': <TokenType.UPDATE: 419>, 'USE': <TokenType.USE: 420>, 'USING': <TokenType.USING: 421>, 'UUID': <TokenType.UUID: 171>, 'VALUES': <TokenType.VALUES: 422>, 'VIEW': <TokenType.VIEW: 424>, 'VOLATILE': <TokenType.VOLATILE: 426>, 'WHEN': <TokenType.WHEN: 428>, 'WHERE': <TokenType.WHERE: 429>, 'WINDOW': <TokenType.WINDOW: 430>, 'WITH': <TokenType.WITH: 431>, 'APPLY': <TokenType.APPLY: 223>, 'ARRAY': <TokenType.ARRAY: 224>, 'BIT': <TokenType.BIT: 97>, 'BOOL': <TokenType.BOOLEAN: 98>, 'BOOLEAN': <TokenType.BOOLEAN: 98>, 'BYTE': <TokenType.TINYINT: 99>, 'MEDIUMINT': <TokenType.MEDIUMINT: 103>, 'INT1': <TokenType.TINYINT: 99>, 'TINYINT': <TokenType.TINYINT: 99>, 'INT16': <TokenType.SMALLINT: 101>, 'SHORT': <TokenType.SMALLINT: 101>, 'SMALLINT': <TokenType.SMALLINT: 101>, 'HUGEINT': <TokenType.INT128: 110>, 'UHUGEINT': <TokenType.UINT128: 111>, 'INT2': <TokenType.SMALLINT: 101>, 'INTEGER': <TokenType.INT: 105>, 'INT': <TokenType.INT: 105>, 'INT4': <TokenType.INT: 105>, 'INT32': <TokenType.INT: 105>, 'INT64': <TokenType.BIGINT: 107>, 'INT128': <TokenType.INT128: 110>, 'INT256': <TokenType.INT256: 112>, 'LONG': <TokenType.BIGINT: 107>, 'BIGINT': <TokenType.BIGINT: 107>, 'INT8': <TokenType.TINYINT: 99>, 'UINT': <TokenType.UINT: 106>, 'UINT128': <TokenType.UINT128: 111>, 'UINT256': <TokenType.UINT256: 113>, 'DEC': <TokenType.DECIMAL: 117>, 'DECIMAL': <TokenType.DECIMAL: 117>, 'DECIMAL32': <TokenType.DECIMAL32: 118>, 'DECIMAL64': <TokenType.DECIMAL64: 119>, 'DECIMAL128': <TokenType.DECIMAL128: 120>, 'DECIMAL256': <TokenType.DECIMAL256: 121>, 'DECFLOAT': <TokenType.DECFLOAT: 122>, 'BIGDECIMAL': <TokenType.BIGDECIMAL: 124>, 'BIGNUMERIC': <TokenType.BIGDECIMAL: 124>, 'BIGNUM': <TokenType.BIGNUM: 109>, 'LIST': <TokenType.LIST: 320>, 'MAP': <TokenType.MAP: 323>, 'NULLABLE': <TokenType.NULLABLE: 174>, 'NUMBER': <TokenType.DECIMAL: 117>, 'NUMERIC': <TokenType.DECIMAL: 117>, 'FIXED': <TokenType.DECIMAL: 117>, 'REAL': <TokenType.FLOAT: 114>, 'FLOAT': <TokenType.FLOAT: 114>, 'FLOAT4': <TokenType.FLOAT: 114>, 'FLOAT8': <TokenType.DOUBLE: 115>, 'DOUBLE': <TokenType.DOUBLE: 115>, 'DOUBLE PRECISION': <TokenType.DOUBLE: 115>, 'JSON': <TokenType.JSON: 141>, 'JSONB': <TokenType.JSONB: 142>, 'CHAR': <TokenType.CHAR: 125>, 'CHARACTER': <TokenType.CHAR: 125>, 'CHAR VARYING': <TokenType.VARCHAR: 127>, 'CHARACTER VARYING': <TokenType.VARCHAR: 127>, 'NCHAR': <TokenType.NCHAR: 126>, 'VARCHAR': <TokenType.VARCHAR: 127>, 'VARCHAR2': <TokenType.VARCHAR: 127>, 'NVARCHAR': <TokenType.NVARCHAR: 128>, 'NVARCHAR2': <TokenType.NVARCHAR: 128>, 'BPCHAR': <TokenType.BPCHAR: 129>, 'STR': <TokenType.TEXT: 130>, 'STRING': <TokenType.TEXT: 130>, 'TEXT': <TokenType.TEXT: 130>, 'LONGTEXT': <TokenType.LONGTEXT: 132>, 'MEDIUMTEXT': <TokenType.MEDIUMTEXT: 131>, 'TINYTEXT': <TokenType.TINYTEXT: 137>, 'CLOB': <TokenType.TEXT: 130>, 'LONGVARCHAR': <TokenType.TEXT: 130>, 'BINARY': <TokenType.BINARY: 139>, 'BLOB': <TokenType.BLOB: 133>, 'LONGBLOB': <TokenType.LONGBLOB: 135>, 'MEDIUMBLOB': <TokenType.MEDIUMBLOB: 134>, 'TINYBLOB': <TokenType.TINYBLOB: 136>, 'BYTEA': <TokenType.VARBINARY: 140>, 'VARBINARY': <TokenType.VARBINARY: 140>, 'TIME': <TokenType.TIME: 143>, 'TIMETZ': <TokenType.TIMETZ: 144>, 'TIME_NS': <TokenType.TIME_NS: 145>, 'TIMESTAMP': <TokenType.TIMESTAMPTZ: 147>, 'TIMESTAMPTZ': <TokenType.TIMESTAMPTZ: 147>, 'TIMESTAMPLTZ': <TokenType.TIMESTAMPLTZ: 148>, 'TIMESTAMP_LTZ': <TokenType.TIMESTAMPLTZ: 148>, 'TIMESTAMPNTZ': <TokenType.TIMESTAMPNTZ: 149>, 'TIMESTAMP_NTZ': <TokenType.TIMESTAMPNTZ: 149>, 'DATE': <TokenType.DATE: 157>, 'DATETIME': <TokenType.DATETIME: 153>, 'INT4RANGE': <TokenType.INT4RANGE: 159>, 'INT4MULTIRANGE': <TokenType.INT4MULTIRANGE: 160>, 'INT8RANGE': <TokenType.INT8RANGE: 161>, 'INT8MULTIRANGE': <TokenType.INT8MULTIRANGE: 162>, 'NUMRANGE': <TokenType.NUMRANGE: 163>, 'NUMMULTIRANGE': <TokenType.NUMMULTIRANGE: 164>, 'TSRANGE': <TokenType.TSRANGE: 165>, 'TSMULTIRANGE': <TokenType.TSMULTIRANGE: 166>, 'TSTZRANGE': <TokenType.TSTZRANGE: 167>, 'TSTZMULTIRANGE': <TokenType.TSTZMULTIRANGE: 168>, 'DATERANGE': <TokenType.DATERANGE: 169>, 'DATEMULTIRANGE': <TokenType.DATEMULTIRANGE: 170>, 'UNIQUE': <TokenType.UNIQUE: 432>, 'VECTOR': <TokenType.VECTOR: 215>, 'STRUCT': <TokenType.STRUCT: 403>, 'SEQUENCE': <TokenType.SEQUENCE: 390>, 'VARIANT': <TokenType.VARIANT: 198>, 'ALTER': <TokenType.ALTER: 219>, 'ANALYZE': <TokenType.ANALYZE: 439>, 'CALL': <TokenType.COMMAND: 237>, 'COMMENT': <TokenType.COMMENT: 238>, 'EXPLAIN': <TokenType.DESCRIBE: 259>, 'GRANT': <TokenType.GRANT: 289>, 'REVOKE': <TokenType.REVOKE: 377>, 'OPTIMIZE': <TokenType.COMMAND: 237>, 'PREPARE': <TokenType.COMMAND: 237>, 'VACUUM': <TokenType.COMMAND: 237>, 'USER-DEFINED': <TokenType.USERDEFINED: 193>, 'CHARSET': <TokenType.CHARACTER_SET: 234>, 'DISTINCTROW': <TokenType.DISTINCT: 262>, 'FORCE': <TokenType.FORCE: 280>, 'IGNORE': <TokenType.IGNORE: 294>, 'KEY': <TokenType.KEY: 313>, 'LOCK TABLES': <TokenType.COMMAND: 237>, 'MEMBER OF': <TokenType.MEMBER_OF: 327>, 'MOD': <TokenType.MOD: 329>, 'SEPARATOR': <TokenType.SEPARATOR: 389>, 'SERIAL': <TokenType.SERIAL: 188>, 'SIGNED': <TokenType.BIGINT: 107>, 'SIGNED INTEGER': <TokenType.BIGINT: 107>, 'START': <TokenType.BEGIN: 229>, 'UNLOCK TABLES': <TokenType.COMMAND: 237>, 'UNSIGNED': <TokenType.UBIGINT: 108>, 'UNSIGNED INTEGER': <TokenType.UBIGINT: 108>, 'YEAR': <TokenType.YEAR: 192>, '_ARMSCII8': <TokenType.INTRODUCER: 306>, '_ASCII': <TokenType.INTRODUCER: 306>, '_BIG5': <TokenType.INTRODUCER: 306>, '_BINARY': <TokenType.INTRODUCER: 306>, '_CP1250': <TokenType.INTRODUCER: 306>, '_CP1251': <TokenType.INTRODUCER: 306>, '_CP1256': <TokenType.INTRODUCER: 306>, '_CP1257': <TokenType.INTRODUCER: 306>, '_CP850': <TokenType.INTRODUCER: 306>, '_CP852': <TokenType.INTRODUCER: 306>, '_CP866': <TokenType.INTRODUCER: 306>, '_CP932': <TokenType.INTRODUCER: 306>, '_DEC8': <TokenType.INTRODUCER: 306>, '_EUCJPMS': <TokenType.INTRODUCER: 306>, '_EUCKR': <TokenType.INTRODUCER: 306>, '_GB18030': <TokenType.INTRODUCER: 306>, '_GB2312': <TokenType.INTRODUCER: 306>, '_GBK': <TokenType.INTRODUCER: 306>, '_GEOSTD8': <TokenType.INTRODUCER: 306>, '_GREEK': <TokenType.INTRODUCER: 306>, '_HEBREW': <TokenType.INTRODUCER: 306>, '_HP8': <TokenType.INTRODUCER: 306>, '_KEYBCS2': <TokenType.INTRODUCER: 306>, '_KOI8R': <TokenType.INTRODUCER: 306>, '_KOI8U': <TokenType.INTRODUCER: 306>, '_LATIN1': <TokenType.INTRODUCER: 306>, '_LATIN2': <TokenType.INTRODUCER: 306>, '_LATIN5': <TokenType.INTRODUCER: 306>, '_LATIN7': <TokenType.INTRODUCER: 306>, '_MACCE': <TokenType.INTRODUCER: 306>, '_MACROMAN': <TokenType.INTRODUCER: 306>, '_SJIS': <TokenType.INTRODUCER: 306>, '_SWE7': <TokenType.INTRODUCER: 306>, '_TIS620': <TokenType.INTRODUCER: 306>, '_UCS2': <TokenType.INTRODUCER: 306>, '_UJIS': <TokenType.INTRODUCER: 306>, '_UTF8': <TokenType.INTRODUCER: 306>, '_UTF16': <TokenType.INTRODUCER: 306>, '_UTF16LE': <TokenType.INTRODUCER: 306>, '_UTF32': <TokenType.INTRODUCER: 306>, '_UTF8MB3': <TokenType.INTRODUCER: 306>, '_UTF8MB4': <TokenType.INTRODUCER: 306>, '@@': <TokenType.SESSION_PARAMETER: 60>}
COMMANDS = {<TokenType.COMMAND: 237>, <TokenType.EXECUTE: 270>, <TokenType.FETCH: 273>, <TokenType.RENAME: 374>, <TokenType.REPLACE: 375>}
BYTE_STRING_ESCAPES: ClassVar[list[str]] = ["'", '"', '\\']
Inherited Members
sqlglot.tokens.Tokenizer
Tokenizer
SINGLE_TOKENS
BYTE_STRINGS
RAW_STRINGS
HEREDOC_STRINGS
UNICODE_STRINGS
VAR_SINGLE_TOKENS
IDENTIFIER_ESCAPES
HEREDOC_TAG_IS_IDENTIFIER
HEREDOC_STRING_ALTERNATIVE
STRING_ESCAPES_ALLOWED_IN_RAW_STRINGS
NUMERIC_ESCAPES
NUMERIC_ESCAPES_ARE_BYTES
LONE_SURROGATE_REPLACEMENT
HINT_START
TOKENS_PRECEDING_HINT
COMMAND_PREFIX_TOKENS
NUMERIC_LITERALS
NUMBERS_CAN_HAVE_DECIMALS
dialect
tokenize
sql
size
tokens