USEthe literal text USE (case insensitive) \sany whitespace character
\[the literal [ (9110 / 1338 / 5B16)
\w+any word character, repeated at least once
\]the literal ] (9310 / 1358 / 5D16)
;?optionally matches the literal ; (5910 / 738 / 3B16)
\s*any whitespace character, repeated any number of times
CREATE VIEW the literal text ↵CREATE VIEW (case insensitive) Group schema(?P<schema>\[\w+\]) \[the literal [ (9110 / 1338 / 5B16)
\w+any word character, repeated at least once
\]the literal ] (9310 / 1358 / 5D16)
\.the literal . (4610 / 568 / 2E16)
Group name(?P<name>\[\w+\]) \[the literal [ (9110 / 1338 / 5B16)
\w+any word character, repeated at least once
\]the literal ] (9310 / 1358 / 5D16)
ASthe literal text ↵AS (case insensitive) \s*any whitespace character, repeated any number of times
the literal ↵ (1010 / 128 / A16)
.+any character, repeated at least once
g modifier: global. Finds all matches instead of stopping after the first
i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters
s modifier: single line. Allows a dot to match line terminators