^start of string
selectthe literal text select (case sensitive) SELECTthe literal text SELECT (case sensitive) the literal (3210 / 408 / 2016)
Group select(?P<select>(.+?)) .+?any character (except for line terminators), repeated at least once
the literal (3210 / 408 / 2016)
fromthe literal text from (case sensitive) FROMthe literal text FROM (case sensitive) the literal (3210 / 408 / 2016)
.+any character (except for line terminators), repeated at least once
the literal (3210 / 408 / 2016)
Group 7((where|WHERE) (?P<where>(.+?))) wherethe literal text where (case sensitive) WHEREthe literal text WHERE (case sensitive) the literal (3210 / 408 / 2016)
Group where(?P<where>(.+?)) .+?any character (except for line terminators), repeated at least once
Group 11( (order by|ORDER BY) (?P<order>(.+?)))? ?repeats the group contents below at most once:
the literal (3210 / 408 / 2016)
Group 12(order by|ORDER BY) order bythe literal text order by (case sensitive) ORDER BYthe literal text ORDER BY (case sensitive) the literal (3210 / 408 / 2016)
Group order(?P<order>(.+?)) .+?any character (except for line terminators), repeated at least once
Group 15( (limit|LIMIT) (?P<limit>(.+)))? ?repeats the group contents below at most once:
the literal (3210 / 408 / 2016)
limitthe literal text limit (case sensitive) the literal (3210 / 408 / 2016)
Group limit(?P<limit>(.+)) $end of string, or before its final line terminator