Regular Expressions 101

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

Pattern to detect certain SQL queries in the PROCESSLIST results.

SQL Query Scalar Field Names Extractor

Finds instances of more than one word in SQL.

as

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

-

find non-sargable sql

but it does not work. How do I make it work? It will be used in C#

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

Splits t-sql script into separated commands. useful for executing with adocommand object

Useful for when you need to convert a T-SQL MSSMS Server batch into individual SQL requests by removing the GO between them. e.g. Dim SQLBatches As String() = Regex.Split(text, "(?:\s|\r|\n)+GO\s*(?:\r|\n)", RegexOptions.IgnoreCase)

13 fields, 12 comma's from right (all left hand ones need to be ignored as they're part of the sql statements)

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.

Parse SQLALCHEMY_DATABASE_URI

matching any SQL query starting by "SELECT foo,bar FROM fool,baz {...}" this one is the good one. first one have a matching alowing * in the FROM statement.