Sql-metadata

sql
SELECT s.cust_id,count(s.cust_id) FROM SH.sales s GROUP BY s.cust_id


This query was giving `s.cust_id` as a table name instead of `SH.sales`. This is now fixed by 54.

* 45 - `get_query_tables`: Add support for `database.schema.table` notation (thanks to dylanhogg)
* 46 - installed dependabot that keeps dependencies up to date
* removed TravisCI integration
* automated PyPI publish on new release creation

* 30 - Improved handling of table aliases
* 39 - Support Python 3.x only
* 41 - handling of newlines in queries fixed (as reported in 37)
* 34 - Support for valid syntax for OUTER JOIN

The following bugs were solved by updating `sqlparse` dependency in 40:

* 31 - CTE makes get_query_tables() case-sensitive for SELECT
* 32 - CTE breaks INSERT INTO ... SELECT and DELETE FROM
* 33 - Add support for ALTER TABLE ... APPEND

* 29 - get_query_tables: fix handling of "SELECT x ORDER BY y" queries
* use [Semantic Versioning](https://semver.org/)

* 25 - Handle `CAST()` and `CONVERT()` functions
* 27 - Handle [Apache Hive queries](https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML#LanguageManualDML-InsertingdataintoHiveTablesfromqueries)

17 - Add support for table schemas in `get_query_tables()`