Analysis of procedural structured query language (sql) codes

A method, comprising:

• parsing, by processing circuitry, a code block comprising a plurality of code elements, each code element corresponding to one of a code block name, a parameter, a variable, a statement, or a condition;
• generating, by the processing circuitry, based on the parsing of the code block, a parse tree that comprises a plurality of nodes for each code element of the plurality of code elements, with each node representing a token of the corresponding code element;
• generating, by the processing circuitry, in the parse tree, one or more directed edges defining dependency between the plurality of code elements such that each directed edge couples two nodes associated with two different code elements;
• generating, by the processing circuitry, a context for at least one code element of the plurality of code elements, the context being indicative of a purpose of the at least one code element in the code block;
• splitting, by the processing circuitry, based on the parse tree with the one or more directed edges, the code block into a plurality of chunks, each chunk comprising at least one of (i) a subset of the code block and (ii) one or more contexts of one or more code elements, of the plurality of code elements, present in the corresponding subset of the code block, respectively;
• and
• processing, by the processing circuitry, the plurality of chunks to generate an output associated with the code block.