Regular Expressions 101

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

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

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

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.

Matches european dates (DD.MM.YYYY[ HH:MM:SS]) and MS-SQL Timestamp ({ts 'YYYY-MM-DD HH:MM:SS'})

Extract the server and database name from SQL Server connection string

this extracts the table name in the from or join clause from SQL query

Contains regex to parse the CockroachDB SQL audit log file

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

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

insert into table ( a, b, c ) values ( " insert into values (1,2,3)",1,2.3,"a,b" ); insert into table (ee,bb,cc) values (aa,234,"asj",2.3);

A regex to find the db wich you're quering against to.