Purpose

These updates to the Query Allowlist feature does three primary tasks:

1. A better deep comparison of the query so queries, for example, with LIMIT 5 and LIMIT 6 are considered different. Previously the ending value was ignored and treated as a ? variable value.
2. When a rejected query fails out of the verification check, log that query to our internal data source. This will help allow us to see what queries are coming through and allow us to quickly and easily mark it as approved if necessary.
3. Stores the source in approved queries so you can specify which source (internal/external) should have the rule applied to it.

Tasks

• Better query value checking for comparisons
• Store rejected queries in the internal data source
• Store source for approved queries

Verify

Before

After