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!