SQL dbname.tablename만 따로 뽑는 정규식

/\s(?:FROM|JOIN)\s+([_.a-zA-Z0-9]+)/img

import re

# sql query

sql = """select * from testdb1.test1 left join testdb1.test2

left join (select * from testdb2.test3) limit 1;"""

# Regular Expression

p = re.compile(r'[(from|join)]\s+(\w+)[.]([_a-zA-Z0-9]+)?')

r=p.findall(sql)

print r

# [('testdb1', 'test1'), ('testdb1', 'test2'), ('testdb2', 'test3')]