jgysland

import re

# this pattern should pick out tablenames or schema.tablenames in 
# most contexts, respecting legal names, including double-quoted table names 
# with otherwise illegal characters.
# known exceptions include GRANT statements and "joins" using multiple tables
# in FROM with WHERE conditions.

pattern = r'(?:from|join|(?:create|alter|drop|truncate|update)' \
           '(?:\s*table|\s*view|\s*)(?:\sas)?)(?:\s+)' \