Converts a JSON-like object of "key": "value" pairs into a SQL CASE statement using a single regex replace with named conditional groups. ✅ Works in PCRE2 flavor only. 🚫 Will not work in JavaScript, Python <3.12, or other engines without conditional replacements.

EXEC\s+SQL\s(?:[\r\n]\s\s)*SELECT

09/21/11 10:47 29 Allow Partner-SQL-eComm 46990 tcp Partner-Web-eComm mysql 19999

fluiddigitalmedia.com

Not fully compliant, please don't use for security or for anything extremely important. Might be a good jumping off point though (although its a bit hellish looking)

Tests for any value that can be converted to a T-SQL numeric type.

Finds the text blocks in a t-sql (tsql) script

Finds the comments in a t-sql (tsql) script

Converts the outcome from an SQL Agent Log (one liner) to multi lines, for easy read

This regex matches the Transact SQL statement for selecting the database and creating a view.

Get all table from sql query string | 从SQL查询语句中获取所有表名。 WelineFramework PHP8 。

find non-sargable sql

Parses MS SQL Server version returned from executing SELECT @@version

-

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).

Contains regex to parse the CockroachDB SQL audit log file

解析php pdo 的 debugDumpParams 输出的数据。

Select the LIMIT/OFFSET clause of an SQL query

SQL comments on Big 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 |.

((LOOP\s+AT\s+\w\s+INTO\s+\w(.?)\s+)((INSERT|DELETE|UPDATE|MODIFY)\s+(\w\.?\?\s+)(FROM\s+\w\.\s*)?(ENDLOOP\.)))

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