Edit on GitHub

sqlglot.dialects.mysql

View Source

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

class MySQL.Tokenizer(sqlglot.tokens.Tokenizer): View Source

 67    class Tokenizer(tokens.Tokenizer):
 68        QUOTES = ["'", '"']
 69        COMMENTS = ["--", "#", ("/*", "*/")]
 70        IDENTIFIERS = ["`"]
 71        STRING_ESCAPES = ["'", '"', "\\"]
 72        BIT_STRINGS = [("b'", "'"), ("B'", "'"), ("0b", "")]
 73        HEX_STRINGS = [("x'", "'"), ("X'", "'"), ("0x", "")]
 74        # https://dev.mysql.com/doc/refman/8.4/en/string-literals.html
 75        ESCAPE_FOLLOW_CHARS = ["0", "b", "n", "r", "t", "Z", "%", "_"]
 76
 77        NESTED_COMMENTS = False
 78
 79        KEYWORDS = {
 80            **tokens.Tokenizer.KEYWORDS,
 81            "BLOB": TokenType.BLOB,
 82            "CHARSET": TokenType.CHARACTER_SET,
 83            "DISTINCTROW": TokenType.DISTINCT,
 84            "EXPLAIN": TokenType.DESCRIBE,
 85            "FORCE": TokenType.FORCE,
 86            "IGNORE": TokenType.IGNORE,
 87            "KEY": TokenType.KEY,
 88            "LOCK TABLES": TokenType.COMMAND,
 89            "LONGBLOB": TokenType.LONGBLOB,
 90            "LONGTEXT": TokenType.LONGTEXT,
 91            "MEDIUMBLOB": TokenType.MEDIUMBLOB,
 92            "MEDIUMINT": TokenType.MEDIUMINT,
 93            "MEDIUMTEXT": TokenType.MEDIUMTEXT,
 94            "MEMBER OF": TokenType.MEMBER_OF,
 95            "MOD": TokenType.MOD,
 96            "SEPARATOR": TokenType.SEPARATOR,
 97            "SERIAL": TokenType.SERIAL,
 98            "SIGNED": TokenType.BIGINT,
 99            "SIGNED INTEGER": TokenType.BIGINT,
100            "SOUNDS LIKE": TokenType.SOUNDS_LIKE,
101            "START": TokenType.BEGIN,
102            "TIMESTAMP": TokenType.TIMESTAMPTZ,
103            "TINYBLOB": TokenType.TINYBLOB,
104            "TINYTEXT": TokenType.TINYTEXT,
105            "UNLOCK TABLES": TokenType.COMMAND,
106            "UNSIGNED": TokenType.UBIGINT,
107            "UNSIGNED INTEGER": TokenType.UBIGINT,
108            "YEAR": TokenType.YEAR,
109            "_ARMSCII8": TokenType.INTRODUCER,
110            "_ASCII": TokenType.INTRODUCER,
111            "_BIG5": TokenType.INTRODUCER,
112            "_BINARY": TokenType.INTRODUCER,
113            "_CP1250": TokenType.INTRODUCER,
114            "_CP1251": TokenType.INTRODUCER,
115            "_CP1256": TokenType.INTRODUCER,
116            "_CP1257": TokenType.INTRODUCER,
117            "_CP850": TokenType.INTRODUCER,
118            "_CP852": TokenType.INTRODUCER,
119            "_CP866": TokenType.INTRODUCER,
120            "_CP932": TokenType.INTRODUCER,
121            "_DEC8": TokenType.INTRODUCER,
122            "_EUCJPMS": TokenType.INTRODUCER,
123            "_EUCKR": TokenType.INTRODUCER,
124            "_GB18030": TokenType.INTRODUCER,
125            "_GB2312": TokenType.INTRODUCER,
126            "_GBK": TokenType.INTRODUCER,
127            "_GEOSTD8": TokenType.INTRODUCER,
128            "_GREEK": TokenType.INTRODUCER,
129            "_HEBREW": TokenType.INTRODUCER,
130            "_HP8": TokenType.INTRODUCER,
131            "_KEYBCS2": TokenType.INTRODUCER,
132            "_KOI8R": TokenType.INTRODUCER,
133            "_KOI8U": TokenType.INTRODUCER,
134            "_LATIN1": TokenType.INTRODUCER,
135            "_LATIN2": TokenType.INTRODUCER,
136            "_LATIN5": TokenType.INTRODUCER,
137            "_LATIN7": TokenType.INTRODUCER,
138            "_MACCE": TokenType.INTRODUCER,
139            "_MACROMAN": TokenType.INTRODUCER,
140            "_SJIS": TokenType.INTRODUCER,
141            "_SWE7": TokenType.INTRODUCER,
142            "_TIS620": TokenType.INTRODUCER,
143            "_UCS2": TokenType.INTRODUCER,
144            "_UJIS": TokenType.INTRODUCER,
145            # https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
146            "_UTF8": TokenType.INTRODUCER,
147            "_UTF16": TokenType.INTRODUCER,
148            "_UTF16LE": TokenType.INTRODUCER,
149            "_UTF32": TokenType.INTRODUCER,
150            "_UTF8MB3": TokenType.INTRODUCER,
151            "_UTF8MB4": TokenType.INTRODUCER,
152            "@@": TokenType.SESSION_PARAMETER,
153        }
154
155        COMMANDS = {*tokens.Tokenizer.COMMANDS, TokenType.REPLACE} - {TokenType.SHOW}

QUOTES = ["'", '"']

COMMENTS = ['--', '#', ('/*', '*/')]

IDENTIFIERS = ['`']

STRING_ESCAPES = ["'", '"', '\\']

BIT_STRINGS = [("b'", "'"), ("B'", "'"), ('0b', '')]

HEX_STRINGS = [("x'", "'"), ("X'", "'"), ('0x', '')]

ESCAPE_FOLLOW_CHARS = ['0', 'b', 'n', 'r', 't', 'Z', '%', '_']

NESTED_COMMENTS = False

KEYWORDS = {'{%': <TokenType.BLOCK_START: 71>, '{%+': <TokenType.BLOCK_START: 71>, '{%-': <TokenType.BLOCK_START: 71>, '%}': <TokenType.BLOCK_END: 72>, '+%}': <TokenType.BLOCK_END: 72>, '-%}': <TokenType.BLOCK_END: 72>, '{{+': <TokenType.BLOCK_START: 71>, '{{-': <TokenType.BLOCK_START: 71>, '+}}': <TokenType.BLOCK_END: 72>, '-}}': <TokenType.BLOCK_END: 72>, '/*+': <TokenType.HINT: 291>, '&<': <TokenType.AMP_LT: 61>, '&>': <TokenType.AMP_GT: 62>, '==': <TokenType.EQ: 28>, '::': <TokenType.DCOLON: 14>, '?::': <TokenType.QDCOLON: 367>, '||': <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.DAMP: 60>, '??': <TokenType.DQMARK: 18>, '~~~': <TokenType.GLOB: 285>, '~~': <TokenType.LIKE: 316>, '~~*': <TokenType.ILIKE: 293>, '~*': <TokenType.IRLIKE: 305>, '-|-': <TokenType.ADJACENT: 63>, 'ALL': <TokenType.ALL: 218>, 'AND': <TokenType.AND: 34>, 'ANTI': <TokenType.ANTI: 219>, 'ANY': <TokenType.ANY: 220>, 'ASC': <TokenType.ASC: 223>, 'AS': <TokenType.ALIAS: 216>, 'ASOF': <TokenType.ASOF: 224>, 'AUTOINCREMENT': <TokenType.AUTO_INCREMENT: 226>, 'AUTO_INCREMENT': <TokenType.AUTO_INCREMENT: 226>, 'BEGIN': <TokenType.BEGIN: 227>, 'BETWEEN': <TokenType.BETWEEN: 228>, 'CACHE': <TokenType.CACHE: 230>, 'UNCACHE': <TokenType.UNCACHE: 411>, 'CASE': <TokenType.CASE: 231>, 'CHARACTER SET': <TokenType.CHARACTER_SET: 232>, 'CLUSTER BY': <TokenType.CLUSTER_BY: 233>, 'COLLATE': <TokenType.COLLATE: 234>, 'COLUMN': <TokenType.COLUMN: 79>, 'COMMIT': <TokenType.COMMIT: 237>, 'CONNECT BY': <TokenType.CONNECT_BY: 238>, 'CONSTRAINT': <TokenType.CONSTRAINT: 239>, 'COPY': <TokenType.COPY: 240>, 'CREATE': <TokenType.CREATE: 241>, 'CROSS': <TokenType.CROSS: 242>, 'CUBE': <TokenType.CUBE: 243>, 'CURRENT_DATE': <TokenType.CURRENT_DATE: 244>, 'CURRENT_SCHEMA': <TokenType.CURRENT_SCHEMA: 246>, 'CURRENT_TIME': <TokenType.CURRENT_TIME: 247>, 'CURRENT_TIMESTAMP': <TokenType.CURRENT_TIMESTAMP: 248>, 'CURRENT_USER': <TokenType.CURRENT_USER: 249>, 'CURRENT_CATALOG': <TokenType.CURRENT_CATALOG: 252>, 'DATABASE': <TokenType.DATABASE: 78>, 'DEFAULT': <TokenType.DEFAULT: 254>, 'DELETE': <TokenType.DELETE: 255>, 'DESC': <TokenType.DESC: 256>, 'DESCRIBE': <TokenType.DESCRIBE: 257>, 'DISTINCT': <TokenType.DISTINCT: 260>, 'DISTRIBUTE BY': <TokenType.DISTRIBUTE_BY: 261>, 'DIV': <TokenType.DIV: 262>, 'DROP': <TokenType.DROP: 263>, 'ELSE': <TokenType.ELSE: 264>, 'END': <TokenType.END: 265>, 'ENUM': <TokenType.ENUM: 203>, 'ESCAPE': <TokenType.ESCAPE: 266>, 'EXCEPT': <TokenType.EXCEPT: 267>, 'EXECUTE': <TokenType.EXECUTE: 268>, 'EXISTS': <TokenType.EXISTS: 269>, 'FALSE': <TokenType.FALSE: 270>, 'FETCH': <TokenType.FETCH: 271>, 'FILTER': <TokenType.FILTER: 274>, 'FILE': <TokenType.FILE: 272>, 'FIRST': <TokenType.FIRST: 276>, 'FULL': <TokenType.FULL: 282>, 'FUNCTION': <TokenType.FUNCTION: 283>, 'FOR': <TokenType.FOR: 277>, 'FOREIGN KEY': <TokenType.FOREIGN_KEY: 279>, 'FORMAT': <TokenType.FORMAT: 280>, 'FROM': <TokenType.FROM: 281>, 'GEOGRAPHY': <TokenType.GEOGRAPHY: 170>, 'GEOMETRY': <TokenType.GEOMETRY: 173>, 'GLOB': <TokenType.GLOB: 285>, 'GROUP BY': <TokenType.GROUP_BY: 288>, 'GROUPING SETS': <TokenType.GROUPING_SETS: 289>, 'HAVING': <TokenType.HAVING: 290>, 'ILIKE': <TokenType.ILIKE: 293>, 'IN': <TokenType.IN: 294>, 'INDEX': <TokenType.INDEX: 295>, 'INET': <TokenType.INET: 198>, 'INNER': <TokenType.INNER: 297>, 'INSERT': <TokenType.INSERT: 298>, 'INTERVAL': <TokenType.INTERVAL: 302>, 'INTERSECT': <TokenType.INTERSECT: 301>, 'INTO': <TokenType.INTO: 303>, 'IS': <TokenType.IS: 306>, 'ISNULL': <TokenType.ISNULL: 307>, 'JOIN': <TokenType.JOIN: 308>, 'KEEP': <TokenType.KEEP: 310>, 'KILL': <TokenType.KILL: 312>, 'LATERAL': <TokenType.LATERAL: 314>, 'LEFT': <TokenType.LEFT: 315>, 'LIKE': <TokenType.LIKE: 316>, 'LIMIT': <TokenType.LIMIT: 317>, 'LOAD': <TokenType.LOAD: 319>, 'LOCALTIME': <TokenType.LOCALTIME: 177>, 'LOCALTIMESTAMP': <TokenType.LOCALTIMESTAMP: 178>, 'LOCK': <TokenType.LOCK: 320>, 'MERGE': <TokenType.MERGE: 326>, 'NAMESPACE': <TokenType.NAMESPACE: 438>, 'NATURAL': <TokenType.NATURAL: 329>, 'NEXT': <TokenType.NEXT: 330>, 'NOT': <TokenType.NOT: 27>, 'NOTNULL': <TokenType.NOTNULL: 332>, 'NULL': <TokenType.NULL: 333>, 'OBJECT': <TokenType.OBJECT: 197>, 'OFFSET': <TokenType.OFFSET: 335>, 'ON': <TokenType.ON: 336>, 'OR': <TokenType.OR: 35>, 'XOR': <TokenType.XOR: 64>, 'ORDER BY': <TokenType.ORDER_BY: 339>, 'ORDINALITY': <TokenType.ORDINALITY: 342>, 'OUT': <TokenType.OUT: 343>, 'OUTER': <TokenType.OUTER: 345>, 'OVER': <TokenType.OVER: 346>, 'OVERLAPS': <TokenType.OVERLAPS: 347>, 'OVERWRITE': <TokenType.OVERWRITE: 348>, 'PARTITION': <TokenType.PARTITION: 350>, 'PARTITION BY': <TokenType.PARTITION_BY: 351>, 'PARTITIONED BY': <TokenType.PARTITION_BY: 351>, 'PARTITIONED_BY': <TokenType.PARTITION_BY: 351>, 'PERCENT': <TokenType.PERCENT: 352>, 'PIVOT': <TokenType.PIVOT: 353>, 'PRAGMA': <TokenType.PRAGMA: 358>, 'PRIMARY KEY': <TokenType.PRIMARY_KEY: 360>, 'PROCEDURE': <TokenType.PROCEDURE: 361>, 'OPERATOR': <TokenType.OPERATOR: 338>, 'QUALIFY': <TokenType.QUALIFY: 365>, 'RANGE': <TokenType.RANGE: 368>, 'RECURSIVE': <TokenType.RECURSIVE: 369>, 'REGEXP': <TokenType.RLIKE: 377>, 'RENAME': <TokenType.RENAME: 371>, 'REPLACE': <TokenType.REPLACE: 372>, 'RETURNING': <TokenType.RETURNING: 373>, 'REFERENCES': <TokenType.REFERENCES: 375>, 'RIGHT': <TokenType.RIGHT: 376>, 'RLIKE': <TokenType.RLIKE: 377>, 'ROLLBACK': <TokenType.ROLLBACK: 379>, 'ROLLUP': <TokenType.ROLLUP: 380>, 'ROW': <TokenType.ROW: 381>, 'ROWS': <TokenType.ROWS: 382>, 'SCHEMA': <TokenType.SCHEMA: 81>, 'SELECT': <TokenType.SELECT: 384>, 'SEMI': <TokenType.SEMI: 385>, 'SESSION': <TokenType.SESSION: 57>, 'SESSION_USER': <TokenType.SESSION_USER: 59>, 'SET': <TokenType.SET: 389>, 'SETTINGS': <TokenType.SETTINGS: 390>, 'SHOW': <TokenType.SHOW: 391>, 'SIMILAR TO': <TokenType.SIMILAR_TO: 392>, 'SOME': <TokenType.SOME: 393>, 'SORT BY': <TokenType.SORT_BY: 394>, 'SQL SECURITY': <TokenType.SQL_SECURITY: 396>, 'START WITH': <TokenType.START_WITH: 397>, 'STRAIGHT_JOIN': <TokenType.STRAIGHT_JOIN: 399>, 'TABLE': <TokenType.TABLE: 82>, 'TABLESAMPLE': <TokenType.TABLE_SAMPLE: 402>, 'TEMP': <TokenType.TEMPORARY: 404>, 'TEMPORARY': <TokenType.TEMPORARY: 404>, 'THEN': <TokenType.THEN: 406>, 'TRUE': <TokenType.TRUE: 407>, 'TRUNCATE': <TokenType.TRUNCATE: 408>, 'TRIGGER': <TokenType.TRIGGER: 409>, 'UNION': <TokenType.UNION: 412>, 'UNKNOWN': <TokenType.UNKNOWN: 212>, 'UNNEST': <TokenType.UNNEST: 413>, 'UNPIVOT': <TokenType.UNPIVOT: 414>, 'UPDATE': <TokenType.UPDATE: 415>, 'USE': <TokenType.USE: 416>, 'USING': <TokenType.USING: 417>, 'UUID': <TokenType.UUID: 169>, 'VALUES': <TokenType.VALUES: 418>, 'VIEW': <TokenType.VIEW: 420>, 'VOLATILE': <TokenType.VOLATILE: 422>, 'WHEN': <TokenType.WHEN: 424>, 'WHERE': <TokenType.WHERE: 425>, 'WINDOW': <TokenType.WINDOW: 426>, 'WITH': <TokenType.WITH: 427>, 'APPLY': <TokenType.APPLY: 221>, 'ARRAY': <TokenType.ARRAY: 222>, 'BIT': <TokenType.BIT: 95>, 'BOOL': <TokenType.BOOLEAN: 96>, 'BOOLEAN': <TokenType.BOOLEAN: 96>, 'BYTE': <TokenType.TINYINT: 97>, 'MEDIUMINT': <TokenType.MEDIUMINT: 101>, 'INT1': <TokenType.TINYINT: 97>, 'TINYINT': <TokenType.TINYINT: 97>, 'INT16': <TokenType.SMALLINT: 99>, 'SHORT': <TokenType.SMALLINT: 99>, 'SMALLINT': <TokenType.SMALLINT: 99>, 'HUGEINT': <TokenType.INT128: 108>, 'UHUGEINT': <TokenType.UINT128: 109>, 'INT2': <TokenType.SMALLINT: 99>, 'INTEGER': <TokenType.INT: 103>, 'INT': <TokenType.INT: 103>, 'INT4': <TokenType.INT: 103>, 'INT32': <TokenType.INT: 103>, 'INT64': <TokenType.BIGINT: 105>, 'INT128': <TokenType.INT128: 108>, 'INT256': <TokenType.INT256: 110>, 'LONG': <TokenType.BIGINT: 105>, 'BIGINT': <TokenType.BIGINT: 105>, 'INT8': <TokenType.TINYINT: 97>, 'UINT': <TokenType.UINT: 104>, 'UINT128': <TokenType.UINT128: 109>, 'UINT256': <TokenType.UINT256: 111>, 'DEC': <TokenType.DECIMAL: 115>, 'DECIMAL': <TokenType.DECIMAL: 115>, 'DECIMAL32': <TokenType.DECIMAL32: 116>, 'DECIMAL64': <TokenType.DECIMAL64: 117>, 'DECIMAL128': <TokenType.DECIMAL128: 118>, 'DECIMAL256': <TokenType.DECIMAL256: 119>, 'DECFLOAT': <TokenType.DECFLOAT: 120>, 'BIGDECIMAL': <TokenType.BIGDECIMAL: 122>, 'BIGNUMERIC': <TokenType.BIGDECIMAL: 122>, 'BIGNUM': <TokenType.BIGNUM: 107>, 'LIST': <TokenType.LIST: 318>, 'MAP': <TokenType.MAP: 321>, 'NULLABLE': <TokenType.NULLABLE: 172>, 'NUMBER': <TokenType.DECIMAL: 115>, 'NUMERIC': <TokenType.DECIMAL: 115>, 'FIXED': <TokenType.DECIMAL: 115>, 'REAL': <TokenType.FLOAT: 112>, 'FLOAT': <TokenType.FLOAT: 112>, 'FLOAT4': <TokenType.FLOAT: 112>, 'FLOAT8': <TokenType.DOUBLE: 113>, 'DOUBLE': <TokenType.DOUBLE: 113>, 'DOUBLE PRECISION': <TokenType.DOUBLE: 113>, 'JSON': <TokenType.JSON: 139>, 'JSONB': <TokenType.JSONB: 140>, 'CHAR': <TokenType.CHAR: 123>, 'CHARACTER': <TokenType.CHAR: 123>, 'CHAR VARYING': <TokenType.VARCHAR: 125>, 'CHARACTER VARYING': <TokenType.VARCHAR: 125>, 'NCHAR': <TokenType.NCHAR: 124>, 'VARCHAR': <TokenType.VARCHAR: 125>, 'VARCHAR2': <TokenType.VARCHAR: 125>, 'NVARCHAR': <TokenType.NVARCHAR: 126>, 'NVARCHAR2': <TokenType.NVARCHAR: 126>, 'BPCHAR': <TokenType.BPCHAR: 127>, 'STR': <TokenType.TEXT: 128>, 'STRING': <TokenType.TEXT: 128>, 'TEXT': <TokenType.TEXT: 128>, 'LONGTEXT': <TokenType.LONGTEXT: 130>, 'MEDIUMTEXT': <TokenType.MEDIUMTEXT: 129>, 'TINYTEXT': <TokenType.TINYTEXT: 135>, 'CLOB': <TokenType.TEXT: 128>, 'LONGVARCHAR': <TokenType.TEXT: 128>, 'BINARY': <TokenType.BINARY: 137>, 'BLOB': <TokenType.BLOB: 131>, 'LONGBLOB': <TokenType.LONGBLOB: 133>, 'MEDIUMBLOB': <TokenType.MEDIUMBLOB: 132>, 'TINYBLOB': <TokenType.TINYBLOB: 134>, 'BYTEA': <TokenType.VARBINARY: 138>, 'VARBINARY': <TokenType.VARBINARY: 138>, 'TIME': <TokenType.TIME: 141>, 'TIMETZ': <TokenType.TIMETZ: 142>, 'TIME_NS': <TokenType.TIME_NS: 143>, 'TIMESTAMP': <TokenType.TIMESTAMPTZ: 145>, 'TIMESTAMPTZ': <TokenType.TIMESTAMPTZ: 145>, 'TIMESTAMPLTZ': <TokenType.TIMESTAMPLTZ: 146>, 'TIMESTAMP_LTZ': <TokenType.TIMESTAMPLTZ: 146>, 'TIMESTAMPNTZ': <TokenType.TIMESTAMPNTZ: 147>, 'TIMESTAMP_NTZ': <TokenType.TIMESTAMPNTZ: 147>, 'DATE': <TokenType.DATE: 155>, 'DATETIME': <TokenType.DATETIME: 151>, 'INT4RANGE': <TokenType.INT4RANGE: 157>, 'INT4MULTIRANGE': <TokenType.INT4MULTIRANGE: 158>, 'INT8RANGE': <TokenType.INT8RANGE: 159>, 'INT8MULTIRANGE': <TokenType.INT8MULTIRANGE: 160>, 'NUMRANGE': <TokenType.NUMRANGE: 161>, 'NUMMULTIRANGE': <TokenType.NUMMULTIRANGE: 162>, 'TSRANGE': <TokenType.TSRANGE: 163>, 'TSMULTIRANGE': <TokenType.TSMULTIRANGE: 164>, 'TSTZRANGE': <TokenType.TSTZRANGE: 165>, 'TSTZMULTIRANGE': <TokenType.TSTZMULTIRANGE: 166>, 'DATERANGE': <TokenType.DATERANGE: 167>, 'DATEMULTIRANGE': <TokenType.DATEMULTIRANGE: 168>, 'UNIQUE': <TokenType.UNIQUE: 428>, 'VECTOR': <TokenType.VECTOR: 213>, 'STRUCT': <TokenType.STRUCT: 400>, 'SEQUENCE': <TokenType.SEQUENCE: 387>, 'VARIANT': <TokenType.VARIANT: 196>, 'ALTER': <TokenType.ALTER: 217>, 'ANALYZE': <TokenType.ANALYZE: 437>, 'CALL': <TokenType.COMMAND: 235>, 'COMMENT': <TokenType.COMMENT: 236>, 'EXPLAIN': <TokenType.DESCRIBE: 257>, 'GRANT': <TokenType.GRANT: 287>, 'REVOKE': <TokenType.REVOKE: 374>, 'OPTIMIZE': <TokenType.COMMAND: 235>, 'PREPARE': <TokenType.COMMAND: 235>, 'VACUUM': <TokenType.COMMAND: 235>, 'USER-DEFINED': <TokenType.USERDEFINED: 191>, 'FOR VERSION': <TokenType.VERSION_SNAPSHOT: 432>, 'FOR TIMESTAMP': <TokenType.TIMESTAMP_SNAPSHOT: 433>, 'CHARSET': <TokenType.CHARACTER_SET: 232>, 'DISTINCTROW': <TokenType.DISTINCT: 260>, 'FORCE': <TokenType.FORCE: 278>, 'IGNORE': <TokenType.IGNORE: 292>, 'KEY': <TokenType.KEY: 311>, 'LOCK TABLES': <TokenType.COMMAND: 235>, 'MEMBER OF': <TokenType.MEMBER_OF: 325>, 'MOD': <TokenType.MOD: 327>, 'SEPARATOR': <TokenType.SEPARATOR: 386>, 'SERIAL': <TokenType.SERIAL: 186>, 'SIGNED': <TokenType.BIGINT: 105>, 'SIGNED INTEGER': <TokenType.BIGINT: 105>, 'SOUNDS LIKE': <TokenType.SOUNDS_LIKE: 395>, 'START': <TokenType.BEGIN: 227>, 'UNLOCK TABLES': <TokenType.COMMAND: 235>, 'UNSIGNED': <TokenType.UBIGINT: 106>, 'UNSIGNED INTEGER': <TokenType.UBIGINT: 106>, 'YEAR': <TokenType.YEAR: 190>, '_ARMSCII8': <TokenType.INTRODUCER: 304>, '_ASCII': <TokenType.INTRODUCER: 304>, '_BIG5': <TokenType.INTRODUCER: 304>, '_BINARY': <TokenType.INTRODUCER: 304>, '_CP1250': <TokenType.INTRODUCER: 304>, '_CP1251': <TokenType.INTRODUCER: 304>, '_CP1256': <TokenType.INTRODUCER: 304>, '_CP1257': <TokenType.INTRODUCER: 304>, '_CP850': <TokenType.INTRODUCER: 304>, '_CP852': <TokenType.INTRODUCER: 304>, '_CP866': <TokenType.INTRODUCER: 304>, '_CP932': <TokenType.INTRODUCER: 304>, '_DEC8': <TokenType.INTRODUCER: 304>, '_EUCJPMS': <TokenType.INTRODUCER: 304>, '_EUCKR': <TokenType.INTRODUCER: 304>, '_GB18030': <TokenType.INTRODUCER: 304>, '_GB2312': <TokenType.INTRODUCER: 304>, '_GBK': <TokenType.INTRODUCER: 304>, '_GEOSTD8': <TokenType.INTRODUCER: 304>, '_GREEK': <TokenType.INTRODUCER: 304>, '_HEBREW': <TokenType.INTRODUCER: 304>, '_HP8': <TokenType.INTRODUCER: 304>, '_KEYBCS2': <TokenType.INTRODUCER: 304>, '_KOI8R': <TokenType.INTRODUCER: 304>, '_KOI8U': <TokenType.INTRODUCER: 304>, '_LATIN1': <TokenType.INTRODUCER: 304>, '_LATIN2': <TokenType.INTRODUCER: 304>, '_LATIN5': <TokenType.INTRODUCER: 304>, '_LATIN7': <TokenType.INTRODUCER: 304>, '_MACCE': <TokenType.INTRODUCER: 304>, '_MACROMAN': <TokenType.INTRODUCER: 304>, '_SJIS': <TokenType.INTRODUCER: 304>, '_SWE7': <TokenType.INTRODUCER: 304>, '_TIS620': <TokenType.INTRODUCER: 304>, '_UCS2': <TokenType.INTRODUCER: 304>, '_UJIS': <TokenType.INTRODUCER: 304>, '_UTF8': <TokenType.INTRODUCER: 304>, '_UTF16': <TokenType.INTRODUCER: 304>, '_UTF16LE': <TokenType.INTRODUCER: 304>, '_UTF32': <TokenType.INTRODUCER: 304>, '_UTF8MB3': <TokenType.INTRODUCER: 304>, '_UTF8MB4': <TokenType.INTRODUCER: 304>, '@@': <TokenType.SESSION_PARAMETER: 58>}

COMMANDS = {<TokenType.COMMAND: 235>, <TokenType.EXECUTE: 268>, <TokenType.FETCH: 271>, <TokenType.RENAME: 371>, <TokenType.REPLACE: 372>}

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; HINT_START; TOKENS_PRECEDING_HINT; COMMAND_PREFIX_TOKENS; NUMERIC_LITERALS; NUMBERS_CAN_HAVE_DECIMALS; dialect; tokenize; sql; size; tokens