Module ImportFrom alias alias ClassDef bases NameLoad body Expr Str FunctionDef arguments args NameParam NameParam defaults body Expr Str FunctionDef arguments args NameParam defaults body Expr Str Assign NameStore Dict Assign NameStore ListLoad Assign NameStore Dict Assign NameStore Dict Assign NameStore Dict Assign AttributeStore NameLoad attr Num Assign NameStore Dict Assign NameStore Dict Assign NameStore Lambda arguments args NameParam defaults CompareEq Call AttributeLoad NameLoad attr Str Assign NameStore Lambda arguments args NameParam defaults CompareEq Call AttributeLoad NameLoad attr Str Assign NameStore Lambda arguments args NameParam defaults CompareEq Call AttributeLoad NameLoad attr Str Assign NameStore Lambda arguments args NameParam defaults CompareEq Call AttributeLoad NameLoad attr Str Assign NameStore Lambda arguments args NameParam defaults BoolOpOr CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr CompareEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str If CompareIs NameLoad NameLoad body Return ListComp NameLoad comprehension NameStore NameLoad BoolOpAnd UnaryOpNot Call AttributeLoad NameLoad attr CompareNotEq Call AttributeLoad NameLoad attr Str Return ListComp NameLoad comprehension NameStore NameLoad BoolOpAnd UnaryOpNot Call AttributeLoad NameLoad attr CompareNotEq Call AttributeLoad NameLoad attr Str CompareNotEq AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str For NameStore NameLoad body If CompareEq Call AttributeLoad NameLoad attr Str body Assign TupleStore NameStore NameStore Call NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad If CompareNotIn NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr NameLoad Assign SubscriptStore NameLoad Index NameLoad NameLoad orelse If Call AttributeLoad NameLoad attr body Expr Call NameLoad AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body If CompareIn AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Assign SubscriptStore NameLoad Index AttributeLoad NameLoad attr AttributeLoad NameLoad attr Return TupleLoad AttributeLoad NameLoad attr NameLoad Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call NameLoad NameLoad If CompareEq Call NameLoad NameLoad Num body Assign NameStore AttributeLoad SubscriptLoad NameLoad Index Num attr If CompareIn AttributeLoad SubscriptLoad NameLoad Index Num attr AttributeLoad NameLoad attr body Assign SubscriptStore NameLoad Index NameLoad NameLoad Assign SubscriptStore NameLoad Index NameLoad TupleLoad NameLoad NameLoad Return TupleLoad NameLoad NameLoad Assign NameStore Call NameLoad GeneratorExp NameLoad comprehension TupleStore NameStore NameStore Call NameLoad NameLoad CompareEq Call AttributeLoad AttributeLoad NameLoad attr attr Str NameLoad If CompareIs NameLoad NameLoad body Assign NameStore Call NameLoad GeneratorExp NameLoad comprehension TupleStore NameStore NameStore Call NameLoad NameLoad Call NameLoad NameLoad NameLoad If CompareIs NameLoad NameLoad body Return TupleLoad BinOpAdd BinOpAdd AttributeLoad SubscriptLoad NameLoad Index Num attr Str AttributeLoad SubscriptLoad NameLoad Index Num attr NameLoad Return Call NameLoad NameLoad Assign NameStore AttributeLoad SubscriptLoad NameLoad Index BinOpAdd NameLoad Num attr Assign NameStore SubscriptLoad NameLoad Slice NameLoad If CompareEq Call NameLoad NameLoad Num body If CompareIn AttributeLoad SubscriptLoad NameLoad Index Num attr AttributeLoad NameLoad attr body Assign SubscriptStore NameLoad Index NameLoad AttributeLoad SubscriptLoad NameLoad Index Num attr Return TupleLoad NameLoad NameLoad orelse If Call NameLoad SubscriptLoad NameLoad Index Num body Return Call NameLoad AttributeLoad SubscriptLoad NameLoad Index Num attr keyword NameLoad orelse If Call NameLoad SubscriptLoad NameLoad Index Num body Assign SubscriptStore NameLoad Index NameLoad TupleLoad Call NameLoad SubscriptLoad NameLoad Index Num NameLoad orelse If Call NameLoad SubscriptLoad NameLoad Index Num body Assign TupleStore NameStore NameStore Call NameLoad SubscriptLoad NameLoad Index Num Assign SubscriptStore NameLoad Index NameLoad TupleLoad NameLoad NameLoad Return TupleLoad NameLoad NameLoad Assign NameStore Call NameLoad GeneratorExp NameLoad comprehension TupleStore NameStore NameStore Call NameLoad NameLoad Call NameLoad NameLoad NameLoad If CompareIs NameLoad NameLoad body Assign SubscriptStore NameLoad Index NameLoad TupleLoad BinOpAdd BinOpAdd AttributeLoad SubscriptLoad NameLoad Index Num attr Str AttributeLoad SubscriptLoad NameLoad Index Num attr NameLoad Return TupleLoad NameLoad NameLoad Return Call NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore AttributeLoad NameLoad attr Assign TupleStore NameStore NameStore NameLoad Assign NameStore SubscriptLoad AttributeLoad NameLoad attr Index Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Assign NameStore SubscriptLoad Call NameLoad NameLoad Index Num Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Expr Str If Call NameLoad NameLoad body Return Call NameLoad NameLoad If Call NameLoad NameLoad body Return ListLoad Call NameLoad NameLoad If Call NameLoad NameLoad body Return Call NameLoad NameLoad Assign NameStore AttributeLoad NameLoad attr If CompareEq Call NameLoad NameLoad Num body If Call NameLoad SubscriptLoad NameLoad Index Num body Return Call NameLoad SubscriptLoad NameLoad Index Num Return Call NameLoad NameLoad Assign NameStore ListLoad For NameStore NameLoad body If Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad orelse If Call NameLoad NameLoad body Expr Call AttributeLoad NameLoad attr Call NameLoad AttributeLoad NameLoad attr orelse If Call NameLoad NameLoad body Assign TupleStore NameStore NameStore Call NameLoad NameLoad Expr Call AttributeLoad NameLoad attr TupleLoad NameLoad NameLoad orelse If BoolOpAnd UnaryOpNot Call AttributeLoad NameLoad attr CompareNotEq AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Expr Call AttributeLoad NameLoad attr Call NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Expr Str Assign NameStore Dict If CompareEq Call NameLoad NameLoad Num body Return Call NameLoad SubscriptLoad NameLoad Index Num Assign NameStore ListComp NameLoad comprehension TupleStore NameStore NameStore Call NameLoad NameLoad Call NameLoad NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore NameLoad Call NameLoad NameLoad Assign NameStore ListLoad SubscriptLoad NameLoad Slice SubscriptLoad NameLoad Index Num AugAssignAdd NameStore ListComp SubscriptLoad NameLoad Slice BinOpAdd NameLoad Num NameLoad comprehension TupleStore NameStore NameStore Call NameLoad SubscriptLoad NameLoad Slice Num SubscriptLoad NameLoad Slice Num AugAssignAdd NameStore ListLoad SubscriptLoad NameLoad Slice BinOpAdd SubscriptLoad NameLoad Index Num Num FunctionDef arguments args NameParam defaults body If CompareGt Call NameLoad NameLoad Num body Return TupleLoad Call AttributeLoad Str attr ListComp AttributeLoad NameLoad attr comprehension NameStore NameLoad NameLoad Assign NameStore SubscriptLoad NameLoad Index Num If CompareEq Call AttributeLoad NameLoad attr Str body Return Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice Num Num If CompareEq Call AttributeLoad NameLoad attr Str body Return TupleLoad AttributeLoad NameLoad attr NameLoad If Call NameLoad NameLoad body Return Call NameLoad NameLoad orelse If Call AttributeLoad NameLoad attr body Return Call NameLoad NameLoad decorator_list Assign NameStore Call NameLoad NameLoad NameLoad Assign NameStore ListComp Call AttributeLoad IfExp CompareIs NameLoad NameLoad NameLoad BinOpAdd BinOpAdd NameLoad Str NameLoad attr Str Str comprehension TupleStore NameStore NameStore NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad NameLoad body TryExcept body Expr Call NameLoad NameLoad handlers ExceptHandler body Assign SubscriptStore NameLoad Index NameLoad NameLoad Assign NameStore Call NameLoad Lambda arguments args NameParam TupleStore NameStore NameStore defaults BinOpAdd BinOpAdd BinOpAdd BinOpAdd NameLoad Str NameLoad Str NameLoad Call NameLoad NameLoad SubscriptLoad NameLoad Slice Num SubscriptLoad NameLoad Index Num If CompareIs NameLoad NameLoad body Assign NameStore Call AttributeLoad Str attr NameLoad Assign NameStore Dict Str Str NameLoad TupleLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Expr Call AttributeLoad NameLoad attr NameLoad Assign SubscriptStore NameLoad Index NameLoad NameLoad Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body Assign NameStore Dict FunctionDef arguments args NameParam defaults body Assign NameStore Dict Str Str Str Str Assign NameStore Call NameLoad NameLoad Assert CompareEq Call NameLoad NameLoad Num Assign TupleStore NameStore NameStore NameStore NameLoad Assign NameStore Call AttributeLoad NameLoad attr AttributeLoad NameLoad attr AttributeLoad NameLoad attr If Call NameLoad NameLoad body Assign TupleStore NameStore NameStore Call NameLoad NameLoad Assign NameStore Call AttributeLoad BinOpAdd BinOpAdd NameLoad Str NameLoad attr Str Str Assign SubscriptStore NameLoad Index NameLoad TupleLoad NameLoad NameLoad orelse If Call AttributeLoad NameLoad attr body Assign NameStore SubscriptLoad Call NameLoad NameLoad Index Num Assign NameStore Call AttributeLoad NameLoad attr Str Str Assign SubscriptStore NameLoad Index NameLoad TupleLoad NameLoad NameLoad If Call AttributeLoad NameLoad attr body Assign NameStore SubscriptLoad Call NameLoad NameLoad Index Num Assign SubscriptStore NameLoad Index Call AttributeLoad NameLoad attr Str Str TupleLoad NameLoad NameLoad orelse Assign NameStore AttributeLoad NameLoad attr Assign NameStore Call AttributeLoad NameLoad attr Str Str Return Call AttributeLoad Str attr keyword NameLoad keyword NameLoad keyword NameLoad decorator_list Assign NameStore SubscriptLoad NameLoad Index Num Assign NameStore Call NameLoad NameLoad If CompareIsNot NameLoad NameLoad body For TupleStore NameStore NameStore Call NameLoad SubscriptLoad NameLoad Slice Num NameLoad body If CompareEq NameLoad Str body AugAssignAdd NameStore BinOpAdd Str Call NameLoad NameLoad orelse If CompareEq NameLoad Str body AugAssignAdd NameStore BinOpAdd Str Call NameLoad NameLoad Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults NameLoad body FunctionDef arguments args NameParam defaults body If Call NameLoad NameLoad body Return Call NameLoad NameLoad orelse Return Call NameLoad NameLoad decorator_list If CompareIs NameLoad NameLoad body AugAssignAdd AttributeStore NameLoad attr Num Assign NameStore BinOpAdd Str Call NameLoad AttributeLoad NameLoad attr Assign NameStore Dict Str Str NameLoad ListLoad Assign NameStore Call NameLoad NameLoad For TupleStore NameStore NameStore Call NameLoad Call NameLoad Call NameLoad NameLoad body If CompareEq AttributeLoad NameLoad attr AttributeLoad AttributeLoad NameLoad attr attr body Break orelse If CompareEq AttributeLoad SubscriptLoad NameLoad Index BinOpSub NameLoad Num attr Str body Assign SubscriptStore NameLoad Index Str Call NameLoad NameLoad orelse If CompareEq AttributeLoad SubscriptLoad NameLoad Index BinOpSub NameLoad Num attr Str body Assign NameStore Call NameLoad NameLoad orelse If Call NameLoad NameLoad body If Call AttributeLoad NameLoad attr body Assign NameStore Call NameLoad ListLoad AttributeLoad NameLoad attr orelse Assign NameStore Call NameLoad ListLoad ListLoad SubscriptLoad NameLoad Index BinOpSub NameLoad Num NameLoad SubscriptLoad NameLoad Index BinOpAdd NameLoad Num Expr Call AttributeLoad SubscriptLoad NameLoad Index Str attr TupleLoad NameLoad NameLoad Assign NameStore Call AttributeLoad NameLoad attr NameLoad ListLoad Expr Call AttributeLoad NameLoad attr NameLoad Assign SubscriptStore NameLoad Index NameLoad NameLoad Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListLoad Assign NameStore Call NameLoad NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareIs AttributeLoad NameLoad attr AttributeLoad NameLoad attr body Return orelse If Call NameLoad NameLoad body Assign NameStore ListLoad Call NameLoad NameLoad orelse If Call AttributeLoad NameLoad attr body Assign NameStore Call NameLoad NameLoad Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body For NameStore NameLoad body If Call NameLoad NameLoad body Return AttributeLoad NameLoad attr decorator_list FunctionDef arguments args NameParam defaults body Expr Str If CompareEq Call NameLoad NameLoad Num body Return BinOpMult TupleLoad AttributeLoad SubscriptLoad NameLoad Index Num attr Num Return TupleLoad AttributeLoad SubscriptLoad NameLoad Index Num attr AttributeLoad SubscriptLoad NameLoad Index Num attr decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore NameLoad For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareEq Call AttributeLoad NameLoad attr Str body Assign TupleStore NameStore NameStore Call NameLoad AttributeLoad SubscriptLoad NameLoad Index BinOpAdd NameLoad Num attr Assign NameStore BinOpAdd Str NameLoad Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice Num Num Assign SubscriptStore NameLoad Index NameLoad NameLoad Delete SubscriptDel NameLoad Index BinOpAdd NameLoad Num orelse If Call AttributeLoad NameLoad attr body Assign TupleStore NameStore NameStore Call NameLoad AttributeLoad NameLoad attr orelse If CompareIn Str AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad SubscriptLoad Call AttributeLoad AttributeLoad NameLoad attr attr Index Num attr Break If CompareIsNot NameLoad NameLoad body Expr Call NameLoad SubscriptLoad NameLoad Slice BinOpAdd NameLoad Num NameLoad Return TupleLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam NameParam defaults body For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareIn Str AttributeLoad NameLoad attr body Assign NameStore Call AttributeLoad SubscriptLoad Call AttributeLoad AttributeLoad NameLoad attr attr Index Num attr Expr Call NameLoad SubscriptLoad NameLoad Slice BinOpAdd NameLoad Num NameLoad Break orelse If CompareEq Call AttributeLoad NameLoad attr Str body Assign TupleStore NameStore NameStore Call NameLoad AttributeLoad SubscriptLoad NameLoad Index BinOpAdd NameLoad Num attr Assign NameStore BinOpAdd Str NameLoad Assign NameStore Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Slice Num Num Assign SubscriptStore NameLoad Index NameLoad NameLoad Delete SubscriptDel NameLoad Index BinOpAdd NameLoad Num orelse If Call NameLoad NameLoad body Assign NameStore SubscriptLoad Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Num Index Num Assign NameStore SubscriptLoad Call NameLoad SubscriptLoad AttributeLoad NameLoad attr Index Num Index Num orelse If Call AttributeLoad NameLoad attr body Assign TupleStore NameStore NameStore Call NameLoad AttributeLoad NameLoad attr Expr Call AttributeLoad NameLoad attr TupleLoad NameLoad NameLoad NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore NameLoad Call NameLoad NameLoad Assign NameStore ListComp AttributeLoad NameLoad attr comprehension NameStore NameLoad CompareIn AttributeLoad NameLoad attr TupleLoad Str Str Return Call NameLoad NameLoad NameLoad decorator_list FunctionDef arguments args NameParam defaults body For NameStore NameLoad body If Call AttributeLoad NameLoad attr body Assign NameStore SubscriptLoad Call NameLoad Call NameLoad NameLoad Index Num Return NameLoad decorator_list FunctionDef arguments args NameParam defaults body For NameStore NameLoad body If Call AttributeLoad NameLoad attr body Assign NameStore Call NameLoad NameLoad Return NameLoad decorator_list Assign NameStore Dict Str Str Str Str Str Str NameLoad NameLoad NameLoad NameLoad NameLoad NameLoad Assign NameStore Call NameLoad NameLoad Assign NameStore Dict For TupleStore NameStore NameStore Call NameLoad NameLoad body If CompareEq NameLoad Num body Assign NameStore Num Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr Continue If CompareEq Call AttributeLoad Call AttributeLoad NameLoad attr attr Str body Assign SubscriptStore NameLoad Index NameLoad Call SubscriptLoad NameLoad Index NameLoad SubscriptLoad NameLoad Slice NameLoad NameLoad Assign NameStore Str Assign SubscriptStore NameLoad Index Str Call SubscriptLoad NameLoad Index Str AttributeLoad NameLoad attr Continue If BoolOpAnd CompareIn Call AttributeLoad AttributeLoad NameLoad attr attr Call AttributeLoad NameLoad attr CompareIn AttributeLoad NameLoad attr AttributeLoad NameLoad attr body If CompareNotEq NameLoad Str body Assign SubscriptStore NameLoad Index NameLoad Call SubscriptLoad NameLoad Index NameLoad SubscriptLoad NameLoad Slice NameLoad NameLoad Assign NameStore NameLoad Assign NameStore Call AttributeLoad AttributeLoad NameLoad attr attr If CompareNotEq NameLoad Str body Assign SubscriptStore NameLoad Index NameLoad Call SubscriptLoad NameLoad Index NameLoad SubscriptLoad NameLoad Slice NameLoad Expr Call NameLoad NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Assign SubscriptStore NameLoad Index Str NameLoad Return NameLoad decorator_list Assign NameStore AttributeLoad SubscriptLoad Call NameLoad NameLoad Index Num attr Return Call NameLoad NameLoad decorator_list decorator_list
N/A sqlparse parse tokens SQLParser N/A object N/A N/A class used to parse sql statements into a data structure
    which can be used to execute the statement parse_statement N/A N/A self statement N/A N/A N/A converts a statement in string form to tokens and passes off to
        the parser parse_tkns N/A N/A tkns N/A N/A N/A parse tokens into datastructure used to execute statement N/A fns N/A N/A joins N/A N/A aliases N/A N/A cases N/A N/A ops N/A N/A N/A self case_num 0 N/A nested_queries N/A N/A literals N/A N/A is_identifier N/A N/A N/A token N/A N/A N/A N/A token _get_repr_name Identifier N/A is_case N/A N/A N/A token N/A N/A N/A N/A token _get_repr_name Case N/A is_function N/A N/A N/A token N/A N/A N/A N/A token _get_repr_name Function N/A is_comparison N/A N/A N/A token N/A N/A N/A N/A token _get_repr_name Comparison N/A is_operator N/A N/A N/A token N/A N/A N/A N/A token ttype N/A tokens Operator N/A N/A token ttype N/A tokens Wildcard strip_tkns N/A N/A tkns punctuation N/A None N/A N/A convenience function to remove whitespace tokens and comments
                from list, optionally also remove punctuation N/A N/A punctuation None N/A N/A N/A token N/A token tkns N/A N/A N/A N/A token is_whitespace N/A N/A N/A token _get_repr_name Comment N/A N/A token N/A token tkns N/A N/A N/A N/A token is_whitespace N/A N/A N/A token _get_repr_name Comment N/A N/A token ttype N/A N/A tokens Token Punctuation N/A get_fns N/A N/A tkns N/A N/A N/A get a dictionary of all functions in statement, needed for
                order of operations with grouping and case statements N/A tkn tkns N/A N/A N/A N/A N/A tkn _get_repr_name Function N/A N/A N/A col fn N/A sql_function tkn N/A _fns N/A N/A fns get col N/A N/A N/A fn _fns N/A N/A N/A N/A _fns append fn N/A N/A fns N/A col _fns N/A N/A N/A N/A tkn is_group N/A N/A N/A get_fns N/A tkn tokens N/A col_identifier N/A N/A token N/A N/A N/A N/A N/A token ttype N/A tokens Literal N/A N/A N/A literals N/A N/A token value N/A token value N/A N/A N/A token value None N/A tkns N/A token tokens N/A tkns N/A strip_tkns tkns N/A N/A N/A len tkns 1 N/A N/A identifier N/A N/A tkns N/A 0 value N/A N/A N/A N/A tkns N/A 0 ttype N/A tokens Literal N/A N/A N/A literals N/A identifier identifier N/A N/A aliases N/A identifier N/A None None N/A N/A identifier None N/A as_idx N/A next N/A i N/A N/A i t N/A enumerate tkns N/A N/A N/A N/A t value upper AS None N/A N/A as_idx None N/A N/A op_idx N/A next N/A i N/A N/A i t N/A enumerate tkns N/A is_operator t None N/A N/A op_idx None N/A N/A N/A N/A N/A N/A N/A tkns N/A 0 value . N/A N/A tkns N/A -1 value None N/A N/A operation tkns N/A as_name N/A N/A tkns N/A N/A as_idx 1 value N/A tkns N/A tkns N/A as_idx N/A N/A N/A len tkns 1 N/A N/A N/A N/A N/A tkns N/A 0 ttype N/A tokens Literal N/A N/A N/A literals N/A as_name N/A N/A tkns N/A 0 value N/A N/A as_name None N/A N/A N/A is_case N/A tkns N/A 0 N/A N/A N/A parse_case N/A N/A tkns N/A 0 tokens as_name as_name N/A N/A N/A is_identifier N/A tkns N/A 0 N/A N/A N/A aliases N/A as_name N/A N/A col_identifier N/A tkns N/A 0 None N/A N/A N/A is_function N/A tkns N/A 0 N/A N/A N/A col fn N/A sql_function N/A tkns N/A 0 N/A N/A aliases N/A as_name N/A col fn N/A N/A as_name None N/A op_idx N/A next N/A i N/A N/A i t N/A enumerate tkns N/A is_operator t None N/A N/A op_idx None N/A N/A N/A aliases N/A as_name N/A N/A N/A N/A N/A tkns N/A 0 value . N/A N/A tkns N/A -1 value None N/A N/A as_name None N/A N/A operation tkns as_name N/A sql_function N/A N/A token N/A N/A N/A tkns N/A token tokens N/A N/A fn parens tkns N/A col N/A N/A parens tokens N/A 1 N/A fn N/A N/A N/A fn value lower N/A col N/A N/A col_identifier col N/A 0 N/A N/A col fn N/A identifier_list N/A N/A token N/A N/A N/A used to parse sql identifiers into actual
                table/column groupings N/A N/A is_identifier token N/A N/A N/A col_identifier token N/A N/A is_function token N/A N/A N/A N/A sql_function token N/A N/A is_case token N/A N/A N/A parse_case token N/A tkns N/A token tokens N/A N/A N/A len tkns 1 N/A N/A N/A is_function N/A tkns N/A 0 N/A N/A N/A sql_function N/A tkns N/A 0 N/A N/A col_identifier token N/A proc N/A N/A tkn tkns N/A N/A N/A is_identifier tkn N/A N/A N/A N/A proc append N/A col_identifier tkn N/A N/A N/A is_case tkn N/A N/A N/A N/A proc append N/A parse_case N/A tkn tokens N/A N/A N/A is_function tkn N/A N/A N/A col fn N/A sql_function tkn N/A N/A N/A proc append N/A col fn N/A N/A N/A N/A N/A N/A tkn is_whitespace N/A N/A tkn ttype N/A tokens Punctuation N/A N/A N/A N/A proc append N/A col_identifier tkn N/A proc N/A operation N/A N/A tkns as_name N/A None N/A N/A perform arithmetic operations N/A identifiers N/A N/A N/A N/A len tkns 1 N/A N/A N/A col_identifier N/A tkns N/A 0 N/A op_indices N/A i N/A N/A i t N/A enumerate tkns N/A is_operator t N/A operators N/A N/A t value N/A t tkns N/A is_operator t N/A ids N/A N/A tkns N/A N/A op_indices N/A 0 N/A ids N/A N/A tkns N/A N/A i1 1 i2 N/A N/A i1 i2 N/A zip N/A op_indices N/A -1 N/A op_indices N/A 1 N/A ids N/A N/A tkns N/A N/A N/A op_indices N/A -1 1 get_id N/A N/A _id N/A N/A N/A N/A N/A len _id 1 N/A N/A N/A N/A N/A join N/A N/A t value N/A t _id None N/A token N/A _id N/A 0 N/A N/A N/A N/A token _get_repr_name Parenthesis N/A N/A N/A operation N/A N/A token tokens N/A 1 -1 N/A N/A N/A N/A token _get_repr_name Integer N/A N/A N/A N/A token value None N/A N/A is_function token N/A N/A N/A sql_function token N/A N/A N/A N/A token is_group N/A N/A N/A col_identifier token N/A N/A ids N/A map get_id ids N/A cols N/A N/A N/A N/A N/A y None x N/A N/A x _ y replace . _ N/A N/A x y ids N/A N/A _id col N/A zip ids cols N/A N/A N/A N/A N/A float col N/A N/A N/A N/A N/A identifiers N/A col _id N/A expr N/A reduce N/A N/A N/A x N/A y z N/A N/A N/A N/A N/A x y z N/A zip operators N/A cols N/A 1 N/A cols N/A 0 N/A N/A as_name None N/A N/A as_name N/A N/A join cols N/A op N/A as_name expr as_name N/A expr identifiers N/A _ops N/A N/A ops get curr_sect N/A N/A N/A N/A _ops append op N/A N/A ops N/A curr_sect _ops N/A N/A as_name None N/A comparison N/A N/A comps operators N/A None N/A N/A identifiers N/A comp_str N/A N/A comp N/A N/A N/A comp_map N/A = <> == != N/A comp N/A strip_tkns comp N/A N/A N/A len comp 3 N/A N/A col comp val comp N/A comp N/A N/A comp_map get N/A comp value N/A comp value N/A N/A is_function col N/A N/A N/A col fn N/A sql_function col N/A col_str N/A N/A N/A N/A col _ fn replace . _ N/A N/A identifiers N/A col_str N/A col fn N/A N/A N/A N/A col is_group N/A N/A col N/A N/A col_identifier col N/A 0 N/A col_str N/A N/A col replace . _ N/A N/A identifiers N/A col_str N/A col None N/A N/A N/A val is_group N/A N/A val N/A N/A col_identifier val N/A 0 N/A N/A identifiers N/A N/A N/A val replace . _ N/A val None N/A N/A val N/A val value N/A val_str N/A N/A val replace . _ N/A N/A N/A ({col} {comp} {val}) format col col_str comp comp val val_str N/A N/A comp N/A comps N/A 0 N/A ev_str N/A comp_str comp N/A N/A operators None N/A N/A N/A comp op N/A zip N/A comps N/A 1 operators N/A N/A N/A op AND N/A N/A ev_str N/A  &  N/A comp_str comp N/A N/A N/A op OR N/A N/A ev_str N/A  |  N/A comp_str comp N/A N/A ev_str identifiers N/A parse_case N/A N/A tkns as_name N/A None N/A get_stmt N/A N/A token N/A N/A N/A N/A is_function token N/A N/A N/A sql_function token N/A N/A N/A col_identifier token N/A N/A N/A as_name None N/A N/A N/A self case_num 1 N/A as_name N/A case N/A str N/A self case_num N/A case N/A as_name stmts as_name N/A N/A tkns N/A strip_tkns tkns N/A N/A i token N/A reversed N/A list N/A enumerate tkns N/A N/A N/A N/A token ttype N/A N/A tokens Keyword CASE N/A N/A N/A N/A N/A N/A N/A tkns N/A N/A i 1 value ELSE N/A N/A N/A case N/A else_stmt N/A get_stmt token N/A N/A N/A N/A N/A tkns N/A N/A i 1 value THEN N/A N/A stmt N/A get_stmt token N/A N/A N/A is_comparison token N/A N/A N/A N/A token is_group N/A N/A cond N/A comparison N/A N/A token tokens N/A N/A cond N/A comparison N/A N/A N/A tkns N/A N/A i 1 token N/A tkns N/A N/A i 1 N/A N/A N/A N/A case N/A stmts append N/A cond stmt N/A _cases N/A N/A cases get curr_sect N/A N/A N/A N/A _cases append case N/A N/A cases N/A curr_sect _cases N/A N/A as_name None N/A parse_select N/A N/A tkns N/A N/A N/A identifiers N/A N/A tkns N/A strip_tkns tkns N/A N/A i token N/A enumerate tkns N/A N/A N/A N/A token ttype N/A tokens Wildcard N/A N/A N/A N/A N/A is_identifier token N/A N/A identifiers N/A N/A col_identifier token N/A N/A N/A N/A token is_group N/A N/A identifiers N/A identifier_list token N/A identifiers N/A parse_into N/A N/A tkns N/A N/A N/A token tkns N/A N/A N/A is_identifier token N/A N/A N/A token value N/A tbl_identifier N/A N/A tkns N/A N/A N/A returns identifier as tuple of
                tablename, identifier N/A N/A N/A len tkns 1 N/A N/A N/A N/A N/A N/A tkns N/A 0 value 2 N/A N/A N/A N/A tkns N/A 0 value N/A N/A tkns N/A -1 value N/A parse_from N/A N/A tkns N/A N/A N/A how None N/A N/A i token N/A enumerate tkns N/A N/A N/A N/A N/A token _get_repr_name Parenthesis N/A N/A N/A table identifier N/A tbl_identifier N/A N/A tkns N/A N/A i 1 tokens N/A table N/A ###temp_ table N/A nested N/A parse_tkns N/A N/A token tokens N/A 1 -1 N/A N/A nested_queries N/A table nested N/A N/A tkns N/A N/A i 1 N/A N/A N/A N/A token is_group N/A N/A N/A table identifier N/A tbl_identifier N/A token tokens N/A N/A N/A JOIN N/A token value N/A N/A how N/A N/A N/A N/A N/A N/A token value split N/A 0 lower N/A N/A N/A how None N/A N/A N/A parse_join N/A tkns N/A N/A i 1 how N/A N/A table identifier N/A parse_join N/A N/A tkns how N/A N/A N/A N/A i token N/A enumerate tkns N/A N/A N/A JOIN N/A token value N/A N/A how_new N/A N/A N/A N/A N/A N/A token value split N/A 0 lower N/A N/A parse_join N/A tkns N/A N/A i 1 how_new N/A N/A N/A N/A N/A N/A token _get_repr_name Parenthesis N/A N/A N/A right right_identifier N/A tbl_identifier N/A N/A tkns N/A N/A i 1 tokens N/A right N/A ###temp_ right N/A nested N/A parse_tkns N/A N/A token tokens N/A 1 -1 N/A N/A nested_queries N/A right nested N/A N/A tkns N/A N/A i 1 N/A N/A N/A is_comparison token N/A N/A left_on N/A N/A col_identifier N/A N/A token tokens N/A 0 N/A 0 N/A right_on N/A N/A col_identifier N/A N/A token tokens N/A -1 N/A 0 N/A N/A N/A N/A token is_group N/A N/A N/A right right_identifier N/A tbl_identifier N/A token tokens N/A N/A N/A joins append N/A right how left_on right_on right_identifier N/A parse_where N/A N/A tkns N/A N/A N/A comps N/A N/A token tokens N/A token tkns N/A is_comparison token N/A operators N/A N/A token value N/A token tkns N/A N/A token value N/A AND OR N/A N/A comparison comps operators N/A parse_group N/A N/A tkns N/A N/A N/A tkn tkns N/A N/A N/A N/A tkn is_group N/A N/A group_by N/A N/A zip N/A identifier_list tkn N/A 0 N/A group_by N/A parse_order N/A N/A tkns N/A N/A N/A token tkns N/A N/A N/A N/A token is_group N/A N/A identifiers N/A identifier_list token N/A identifiers N/A N/A sections N/A SELECT INTO FROM WHERE GROUP ORDER parse_select parse_into parse_from parse_where parse_group parse_order N/A tkns N/A strip_tkns tkns N/A _parsed N/A N/A N/A i token N/A enumerate tkns N/A N/A N/A i 0 N/A N/A start 0 N/A curr_sect N/A N/A N/A token value upper N/A N/A N/A N/A N/A N/A N/A token _get_repr_name upper WHERE N/A N/A N/A _parsed N/A curr_sect N/A N/A sections N/A curr_sect N/A tkns N/A start i N/A curr_sect WHERE N/A N/A _parsed N/A WHERE N/A N/A sections N/A WHERE N/A token tokens N/A N/A N/A N/A N/A N/A N/A token value upper N/A N/A sections keys N/A N/A token ttype N/A tokens Keyword N/A N/A N/A curr_sect WHERE N/A N/A N/A _parsed N/A curr_sect N/A N/A sections N/A curr_sect N/A tkns N/A start i N/A start i N/A curr_sect N/A N/A N/A token value upper N/A N/A curr_sect WHERE N/A N/A N/A _parsed N/A curr_sect N/A N/A sections N/A curr_sect N/A tkns N/A start N/A N/A get_fns tkns N/A N/A _parsed N/A FUNCTIONS fns N/A N/A _parsed N/A JOINS joins N/A N/A _parsed N/A ALIASES aliases N/A N/A _parsed N/A CASES cases N/A N/A _parsed N/A NESTED_QUERIES nested_queries N/A N/A _parsed N/A OPS ops N/A N/A _parsed N/A LITERALS literals N/A _parsed N/A N/A tkns N/A N/A N/A parse statement N/A 0 tokens N/A N/A parse_tkns tkns N/A N/A