m/insert\s+into\s+(\S+)\s*\(\s*([^)]+?)\s*\)\s*
   (?:values\s*\(\s*([^)]+?)\s*\)
    |
      select\s*(.+?)\s+(?:where|order)
   )
 /ix

##</code><code>##

m/insert\s+into\s+(\S+)\s*\(\s*([^)]+?)\s*\)\s*
   (?:values\s*\(\s*([^)]+?)\s*\)
    |
      select\s*(.+?)\s+(?:from\b)
   )
 /ix