sql-metadata is a Python library that parses SQL queries and extracts tables, columns, aliases, query types, subqueries and comments.