{
    "query": "CREATE VIEW  `employees_view` AS\nSELECT *\nFROM\n    `employees`\nWHERE\n    `employees`.`gender` = 'M'\nUNION\nSELECT *\nFROM\n    `employees`\nWHERE\n    `employees`.`gender` = 'F';",
    "lexer": {
        "@type": "PhpMyAdmin\\SqlParser\\Lexer",
        "str": "CREATE VIEW  `employees_view` AS\nSELECT *\nFROM\n    `employees`\nWHERE\n    `employees`.`gender` = 'M'\nUNION\nSELECT *\nFROM\n    `employees`\nWHERE\n    `employees`.`gender` = 'F';",
        "len": 173,
        "last": 173,
        "list": {
            "@type": "PhpMyAdmin\\SqlParser\\TokensList",
            "tokens": [
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "CREATE",
                    "value": "CREATE",
                    "keyword": "CREATE",
                    "type": 1,
                    "flags": 3,
                    "position": 0
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 6
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "VIEW",
                    "value": "VIEW",
                    "keyword": "VIEW",
                    "type": 1,
                    "flags": 1,
                    "position": 7
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "  ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 11
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`employees_view`",
                    "value": "employees_view",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 13
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 29
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "AS",
                    "value": "AS",
                    "keyword": "AS",
                    "type": 1,
                    "flags": 3,
                    "position": 30
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 32
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SELECT",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 33
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 39
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "*",
                    "value": "*",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 40
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 41
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FROM",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 42
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 46
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`employees`",
                    "value": "employees",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 51
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 62
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "WHERE",
                    "value": "WHERE",
                    "keyword": "WHERE",
                    "type": 1,
                    "flags": 3,
                    "position": 63
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 68
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`employees`",
                    "value": "employees",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 73
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 84
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`gender`",
                    "value": "gender",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 85
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 93
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 94
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 95
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'M'",
                    "value": "M",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 96
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 99
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "UNION",
                    "value": "UNION",
                    "keyword": "UNION",
                    "type": 1,
                    "flags": 3,
                    "position": 100
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 105
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "SELECT",
                    "value": "SELECT",
                    "keyword": "SELECT",
                    "type": 1,
                    "flags": 3,
                    "position": 106
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 112
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "*",
                    "value": "*",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 113
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 114
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "FROM",
                    "value": "FROM",
                    "keyword": "FROM",
                    "type": 1,
                    "flags": 3,
                    "position": 115
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 119
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`employees`",
                    "value": "employees",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 124
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 135
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "WHERE",
                    "value": "WHERE",
                    "keyword": "WHERE",
                    "type": 1,
                    "flags": 3,
                    "position": 136
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "\n    ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 141
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`employees`",
                    "value": "employees",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 146
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ".",
                    "value": ".",
                    "keyword": null,
                    "type": 2,
                    "flags": 16,
                    "position": 157
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "`gender`",
                    "value": "gender",
                    "keyword": null,
                    "type": 8,
                    "flags": 2,
                    "position": 158
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 166
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "=",
                    "value": "=",
                    "keyword": null,
                    "type": 2,
                    "flags": 2,
                    "position": 167
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": " ",
                    "value": " ",
                    "keyword": null,
                    "type": 3,
                    "flags": 0,
                    "position": 168
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": "'F'",
                    "value": "F",
                    "keyword": null,
                    "type": 7,
                    "flags": 1,
                    "position": 169
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": ";",
                    "value": ";",
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": 172
                },
                {
                    "@type": "PhpMyAdmin\\SqlParser\\Token",
                    "token": null,
                    "value": null,
                    "keyword": null,
                    "type": 9,
                    "flags": 0,
                    "position": null
                }
            ],
            "count": 47,
            "idx": 47
        },
        "delimiter": ";",
        "delimiterLen": 1,
        "strict": false,
        "errors": []
    },
    "parser": {
        "@type": "PhpMyAdmin\\SqlParser\\Parser",
        "list": {
            "@type": "@1"
        },
        "statements": [
            {
                "@type": "PhpMyAdmin\\SqlParser\\Statements\\CreateStatement",
                "name": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                    "database": null,
                    "table": "employees_view",
                    "column": null,
                    "expr": "`employees_view`",
                    "alias": null,
                    "function": null,
                    "subquery": null
                },
                "entityOptions": null,
                "fields": null,
                "with": null,
                "select": {
                    "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement",
                    "expr": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": null,
                            "column": null,
                            "expr": "*",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        }
                    ],
                    "from": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression",
                            "database": null,
                            "table": "employees",
                            "column": null,
                            "expr": "`employees`",
                            "alias": null,
                            "function": null,
                            "subquery": null
                        }
                    ],
                    "index_hints": null,
                    "partition": null,
                    "where": [
                        {
                            "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition",
                            "identifiers": [
                                "employees",
                                "gender",
                                "M"
                            ],
                            "isOperator": false,
                            "expr": "`employees`.`gender` = 'M'"
                        }
                    ],
                    "group": null,
                    "group_options": null,
                    "having": null,
                    "order": null,
                    "limit": null,
                    "procedure": null,
                    "into": null,
                    "join": null,
                    "union": [],
                    "end_options": null,
                    "options": {
                        "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                        "options": []
                    },
                    "first": 8,
                    "last": 25
                },
                "like": null,
                "partitionBy": null,
                "partitionsNum": null,
                "subpartitionBy": null,
                "subpartitionsNum": null,
                "partitions": null,
                "table": null,
                "return": null,
                "parameters": null,
                "body": [
                    {
                        "@type": "@28"
                    },
                    {
                        "@type": "@29"
                    },
                    {
                        "@type": "@30"
                    },
                    {
                        "@type": "@31"
                    },
                    {
                        "@type": "@32"
                    },
                    {
                        "@type": "@33"
                    },
                    {
                        "@type": "@34"
                    },
                    {
                        "@type": "@35"
                    },
                    {
                        "@type": "@36"
                    },
                    {
                        "@type": "@37"
                    },
                    {
                        "@type": "@38"
                    },
                    {
                        "@type": "@39"
                    },
                    {
                        "@type": "@40"
                    },
                    {
                        "@type": "@41"
                    },
                    {
                        "@type": "@42"
                    },
                    {
                        "@type": "@43"
                    },
                    {
                        "@type": "@44"
                    },
                    {
                        "@type": "@45"
                    },
                    {
                        "@type": "@46"
                    }
                ],
                "options": {
                    "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray",
                    "options": {
                        "6": "VIEW"
                    }
                },
                "first": 0,
                "last": 45
            }
        ],
        "brackets": 0,
        "strict": false,
        "errors": []
    },
    "errors": {
        "lexer": [],
        "parser": []
    }
}