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