Systems and methods for SQL query constraint solving

A system for analyzing SQL queries for constraint violations comprising:

• a processor executing computer readable medium to:
• tokenize a SQL query to generate a token stream;
• generate lexical nodes by iterating over the token stream to chunk into SQL commands, SQL functions and field/table identifiers;
• construct a parse tree by iterating over the lexical nodes;
• analyze the parse tree for constraint violations by comparing the parse tree to a SQL schema and access configuration for a database, wherein the query constraint solver is further configured to identify invalid fields and table access, wherein identifying invalid fields and table access comprises identifying parse tree identifiers for fields or tables that do not exist or for which access is restricted;
• and
• perform risk mitigation for SQL queries that are likely harboring an SQL injection attack.