find non-sargable sql

-

Usage: pcre2grep -M -e'^(CREATE TABLE*?;)' dump.sql > create-tables.sql

as

Finds instances of more than one word in SQL.

SQL Query Scalar Field Names Extractor

Pattern to detect certain SQL queries in the PROCESSLIST results.

An example false positive matching docstring for the regex used by flake8-sql (https://github.com/pgjones/flake8-sql).

Select the LIMIT/OFFSET clause of an SQL query

Regex for checking if JSON starts with desired keys Useful for validating/filtering database entries when used in combination with SQL Like Example: Postgre: select * from table_name where column_json ~ '^\{[\s]\"(tab1|tab3|tab5)".'

Just need to remove the last ,

Find all commas that are not in parenthesis or square brackets.

This is used in the SQL_Pretty_Formatter after the commas inside quotes, parenthesis, and brackets have been temporarily replaced with |.

Check whether or not the SQL is dangerous!

Search in sql script generated using SCA for the implicit constraint names and defining the name explicityly

Search in sql script generated using SCA for the implicit constraint names and defining the name explicityly

Grabs all but last SVN keyword. Uses "," as delimiter (need to get rid of (Wed 26 Aug 2018) first) PL/SQL: Unit: ZIP_UTIL_PKG, type: PACKAGE BODY. Code Type: NATIVE. SVN: File date: $Date: 2019-08-26 10:28:11 -0500 $, Revision: $Revision: 18213 $, $Author: mark.s $.

Note to escape % characters beforehand.

Find all insert sql grouped by columns and values

Find all insert sql grouped by columns and values

Insert GROUP BY statement for parameter (if there is already another "GROUP BY")

Insert GROUP BY statement for a parameter (if no previous "GROUP BY" is present)

Insert GROUP BY statement for parameter (if there is no "GROUP BY" yet)

Gibt alle Spaltennamen zurück

Obtains the SQL params

Convert SQL to FLOW

From https://raw.githubusercontent.com/SpiderLabs/owasp-modsecurity-crs/v3.0/master/rules/REQUEST-942-APPLICATION-ATTACK-SQLI.conf

Pattern from https://raw.githubusercontent.com/SpiderLabs/owasp-modsecurity-crs/v3.0/master/rules/REQUEST-942-APPLICATION-ATTACK-SQLI.conf

Parses a very basic SQL INSERT statement of the form: INSERT INTO VALUES ()