{ "query": "WITH categories(identifier, name, parent_id) AS ( SELECT c.identifier, c.name, c.parent_id FROM category c WHERE c.identifier = 'a' UNION ALL SELECT c.identifier, c.name, c.parent_id FROM categories, category c WHERE c.identifier = categories.parent_id ), foo AS ( SELECT * FROM test ) SELECT * FROM categories", "lexer": { "@type": "PhpMyAdmin\\SqlParser\\Lexer", "str": "WITH categories(identifier, name, parent_id) AS ( SELECT c.identifier, c.name, c.parent_id FROM category c WHERE c.identifier = 'a' UNION ALL SELECT c.identifier, c.name, c.parent_id FROM categories, category c WHERE c.identifier = categories.parent_id ), foo AS ( SELECT * FROM test ) SELECT * FROM categories", "len": 310, "last": 310, "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WITH", "value": "WITH", "keyword": "WITH", "type": 1, "flags": 3, "position": 0 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 4 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "categories", "value": "categories", "keyword": null, "type": 0, "flags": 0, "position": 5 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 15 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "identifier", "value": "identifier", "keyword": null, "type": 0, "flags": 0, "position": 16 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 26 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 27 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 1, "flags": 1, "position": 28 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 32 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 33 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 34 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 43 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 44 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 45 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 47 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 48 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 49 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 50 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 56 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 57 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 58 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "identifier", "value": "identifier", "keyword": null, "type": 0, "flags": 0, "position": 59 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 69 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 70 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 71 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 72 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 0, "flags": 0, "position": 73 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 77 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 78 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 79 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 80 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 81 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 90 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 91 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 95 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "category", "value": "category", "keyword": null, "type": 0, "flags": 0, "position": 96 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 104 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 105 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 106 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 107 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 112 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 113 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 114 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "identifier", "value": "identifier", "keyword": null, "type": 0, "flags": 0, "position": 115 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 125 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 126 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 127 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "'a'", "value": "a", "keyword": null, "type": 7, "flags": 1, "position": 128 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 131 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "UNION ALL", "value": "UNION ALL", "keyword": "UNION ALL", "type": 1, "flags": 7, "position": 132 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 141 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 142 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 148 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 149 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 150 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "identifier", "value": "identifier", "keyword": null, "type": 0, "flags": 0, "position": 151 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 161 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 162 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 163 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 164 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "name", "value": "name", "keyword": "NAME", "type": 0, "flags": 0, "position": 165 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 169 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 170 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 171 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 172 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 173 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 182 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 183 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 187 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "categories", "value": "categories", "keyword": null, "type": 0, "flags": 0, "position": 188 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 198 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 199 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "category", "value": "category", "keyword": null, "type": 0, "flags": 0, "position": 200 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 208 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 209 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 210 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "WHERE", "value": "WHERE", "keyword": "WHERE", "type": 1, "flags": 3, "position": 211 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 216 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "c", "value": "c", "keyword": null, "type": 0, "flags": 0, "position": 217 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 218 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "identifier", "value": "identifier", "keyword": null, "type": 0, "flags": 0, "position": 219 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 229 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "=", "value": "=", "keyword": null, "type": 2, "flags": 2, "position": 230 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 231 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "categories", "value": "categories", "keyword": null, "type": 0, "flags": 0, "position": 232 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ".", "value": ".", "keyword": null, "type": 2, "flags": 16, "position": 242 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "parent_id", "value": "parent_id", "keyword": null, "type": 0, "flags": 0, "position": 243 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 252 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 253 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ",", "value": ",", "keyword": null, "type": 2, "flags": 16, "position": 254 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 255 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "foo", "value": "foo", "keyword": null, "type": 0, "flags": 0, "position": 256 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 259 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "AS", "value": "AS", "keyword": "AS", "type": 1, "flags": 3, "position": 260 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 262 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "(", "value": "(", "keyword": null, "type": 2, "flags": 16, "position": 263 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 264 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 265 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 271 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 272 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 273 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 274 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 278 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "test", "value": "test", "keyword": null, "type": 0, "flags": 0, "position": 279 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 283 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": ")", "value": ")", "keyword": null, "type": 2, "flags": 16, "position": 284 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 285 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "SELECT", "value": "SELECT", "keyword": "SELECT", "type": 1, "flags": 3, "position": 286 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 292 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "*", "value": "*", "keyword": null, "type": 2, "flags": 16, "position": 293 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 294 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "FROM", "value": "FROM", "keyword": "FROM", "type": 1, "flags": 3, "position": 295 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": " ", "value": " ", "keyword": null, "type": 3, "flags": 0, "position": 299 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": "categories", "value": "categories", "keyword": null, "type": 0, "flags": 0, "position": 300 }, { "@type": "PhpMyAdmin\\SqlParser\\Token", "token": null, "value": null, "keyword": null, "type": 9, "flags": 0, "position": null } ], "count": 115, "idx": 115 }, "delimiter": ";", "delimiterLen": 1, "strict": false, "errors": [] }, "parser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "@1" }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\WithStatement", "withers": { "categories": { "@type": "PhpMyAdmin\\SqlParser\\Components\\WithKeyword", "name": "categories", "columns": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\ArrayObj", "raw": [ "identifier", "name", "parent_id" ], "values": [ "identifier", "name", "parent_id" ] } ], "statement": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@18" }, { "@type": "@19" }, { "@type": "@20" }, { "@type": "@21" }, { "@type": "@22" }, { "@type": "@23" }, { "@type": "@24" }, { "@type": "@25" }, { "@type": "@26" }, { "@type": "@27" }, { "@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" }, { "@type": "@47" }, { "@type": "@48" }, { "@type": "@49" }, { "@type": "@50" }, { "@type": "@51" }, { "@type": "@52" }, { "@type": "@53" }, { "@type": "@54" }, { "@type": "@55" }, { "@type": "@56" }, { "@type": "@57" }, { "@type": "@58" }, { "@type": "@59" }, { "@type": "@60" }, { "@type": "@61" }, { "@type": "@62" }, { "@type": "@63" }, { "@type": "@64" }, { "@type": "@65" }, { "@type": "@66" }, { "@type": "@67" }, { "@type": "@68" }, { "@type": "@69" }, { "@type": "@70" }, { "@type": "@71" }, { "@type": "@72" }, { "@type": "@73" }, { "@type": "@74" }, { "@type": "@75" }, { "@type": "@76" }, { "@type": "@77" }, { "@type": "@78" }, { "@type": "@79" }, { "@type": "@80" }, { "@type": "@81" }, { "@type": "@82" }, { "@type": "@83" }, { "@type": "@84" }, { "@type": "@85" }, { "@type": "@86" }, { "@type": "@87" }, { "@type": "@88" }, { "@type": "@89" } ], "count": 72, "idx": 72 }, "statements": [ { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "identifier", "expr": "c.identifier", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "name", "expr": "c.name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "parent_id", "expr": "c.parent_id", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "category", "column": null, "expr": "category", "alias": "c", "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "c", "identifier", "a" ], "isOperator": false, "expr": "c.identifier = 'a'" } ], "group": null, "group_options": null, "having": null, "order": null, "limit": null, "procedure": null, "into": null, "join": null, "union": [ [ "UNION ALL", { "@type": "PhpMyAdmin\\SqlParser\\Statements\\SelectStatement", "expr": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "identifier", "expr": "c.identifier", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "name", "expr": "c.name", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "c", "column": "parent_id", "expr": "c.parent_id", "alias": null, "function": null, "subquery": null } ], "from": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "categories", "column": null, "expr": "categories", "alias": null, "function": null, "subquery": null }, { "@type": "PhpMyAdmin\\SqlParser\\Components\\Expression", "database": null, "table": "category", "column": null, "expr": "category", "alias": "c", "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": [ { "@type": "PhpMyAdmin\\SqlParser\\Components\\Condition", "identifiers": [ "c", "identifier", "categories", "parent_id" ], "isOperator": false, "expr": "c.identifier = categories.parent_id" } ], "group": null, "group_options": null, "having": null, "order": [], "limit": null, "procedure": null, "into": null, "join": null, "union": [], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 33, "last": 71 } ] ], "end_options": null, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 71 } ], "brackets": 0, "strict": false, "errors": [] } }, "foo": { "@type": "PhpMyAdmin\\SqlParser\\Components\\WithKeyword", "name": "foo", "columns": [], "statement": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@98" }, { "@type": "@99" }, { "@type": "@100" }, { "@type": "@101" }, { "@type": "@102" }, { "@type": "@103" }, { "@type": "@104" }, { "@type": "@105" }, { "@type": "@106" } ], "count": 9, "idx": 9 }, "statements": [ { "@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": "test", "column": null, "expr": "test", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "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": 0, "last": 8 } ], "brackets": 0, "strict": false, "errors": [] } } }, "cteStatementParser": { "@type": "PhpMyAdmin\\SqlParser\\Parser", "list": { "@type": "PhpMyAdmin\\SqlParser\\TokensList", "tokens": [ { "@type": "@109" }, { "@type": "@110" }, { "@type": "@111" }, { "@type": "@112" }, { "@type": "@113" }, { "@type": "@114" }, { "@type": "@115" }, { "@type": "@116" } ], "count": 8, "idx": 8 }, "statements": [ { "@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": "categories", "column": null, "expr": "categories", "alias": null, "function": null, "subquery": null } ], "index_hints": null, "partition": null, "where": null, "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": 0, "last": 6 } ], "brackets": 0, "strict": false, "errors": [] }, "options": { "@type": "PhpMyAdmin\\SqlParser\\Components\\OptionsArray", "options": [] }, "first": 0, "last": 113 } ], "brackets": 0, "strict": false, "errors": [] }, "errors": { "lexer": [], "parser": [] } }