RegEx T-SQL Parser for extracting sources and destinations from the INSERT statement

sql-parser.regex

(insert (?: \s (?:bulk|into))?) \s 
(?(?=openquery) (?:
    (openquery) \s \(
    (\S+?) \, \s \' .+? \'\)
  )
  | (\S+)
)
.+?
select

(?:.+?(from|join) \s (\S+))+


(?<i_cl>insert (?: \s (?: into | bulk ))?) \s

  (?(?=openquery) (?:
      (?<i_oq>openquery) \s \(
        (?<i_oq_srv>\S+) \, \s \'
        .*?
        \'\)
    ) 
    | (?:
      (?<i_tbl>\S+)
    )
  )

.*? \s select \s .*?
(?:
(?<f_cl>from) \s

(?(?=openquery) (?:
  (?<f_oq>openquery) \s \(
    (?<f_oq_srv>\S+) \, \s \'
    (?: .+? (?<f_oq_cl>from|join) \s (?<f_oq_tbl>\S+) )
    .* \'\)
  ) 
  | (?: (?<f_tbl>\S+) )
)
)+