Non-Capturing Group(?:\G(?!\A),|SELECT) \Gstart of current search
,the literal , (4410 / 548 / 2C16)
SELECTthe literal text SELECT (case sensitive) Non-Capturing Group(?:\s+[^\s,]+(?:\([^()]*\))?,)* *repeats the group contents below any number of times:
\s+any whitespace character, repeated at least once
Negated Character Class[^\s,]+ +matches at least one character outside the set below:
\sany whitespace character
,the literal , (4410 / 548 / 2C16)
Non-Capturing Group(?:\([^()]*\))? ?repeats the group contents below at most once:
\(the literal ( (4010 / 508 / 2816)
Negated Character Class[^()]* *matches any number of characters outside the set below:
(the literal ( (4010 / 508 / 2816)
)the literal ) (4110 / 518 / 2916)
\)the literal ) (4110 / 518 / 2916)
,the literal , (4410 / 548 / 2C16)
\s*any whitespace character, repeated any number of times
\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match
Negated Character Class[^\s,]+ +matches at least one character outside the set below:
\sany whitespace character
,the literal , (4410 / 548 / 2C16)
\s*any whitespace character, repeated any number of times
Non-Capturing Group(?:(?![()',])[[:punct:]]|AS) 1st Alternative(?![()',])[[:punct:]] Negative Lookahead(?![()',]) (the literal ( (4010 / 508 / 2816)
)the literal ) (4110 / 518 / 2916)
'the literal ' (3910 / 478 / 2716)
,the literal , (4410 / 548 / 2C16)
Character Class[[:punct:]] [:punct:]a punctuation character [!"#$%&'()*+,\-./:;<=>?@[\]^_`{|}~]
ASthe literal text AS (case sensitive) \s*any whitespace character, repeated any number of times
Non-Capturing Group(?:(?!FROM)[^,])* *repeats the group contents below any number of times:
Negative Lookahead(?!FROM) FROMthe literal text FROM (case sensitive) Negated Character Class[^,] ,the literal , (4410 / 548 / 2C16)
g modifier: global. Finds all matches instead of stopping after the first
m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string