Sql-metadata

* 100 `internals` - Lint after running tests
* 101 `dependencies` - build(deps-dev): bump pylint from 2.6.2 to 2.7.0 (by dependabot[bot])
* 102 `dependencies` - build(deps-dev): bump pylint from 2.7.0 to 2.7.1 (by dependabot[bot])
* 104 `dependencies` - build(deps-dev): bump coverage from 5.4 to 5.5 (by dependabot[bot])
* 108 `internals` - Use poetry 1.1.5
* 109 `internals` - CI - store ~/.cache dir + pip install wheel
* 110 `internals` - actions/cache: invalidate on poetry.lock change
* 113 `enhancement` - Improved brackets handling
* 116 `dependencies` - build(deps-dev): bump pytest from 6.2.2 to 6.2.3 (by dependabot[bot])
* 117 `dependencies` - snok/install-poetryv1.1.3
* 118 `dependencies` - build(deps-dev): bump pylint from 2.7.4 to 2.8.1 (by dependabot[bot])
* 119 `dependencies` - build(deps-dev): bump pylint from 2.8.1 to 2.8.2 (by dependabot[bot])
* 123 `dependencies` - Upgrade black to 21.4b1
* 124 `dependencies` - build(deps-dev): bump black from 21.4b1 to 21.4b2 (by dependabot[bot])

This release brings two bug fixes from aborecki (dzięki! 🙂 🇵🇱 ) and introduces [`poetry` as the dependency manager](https://python-poetry.org/docs/).

Changelog

* 79 `bug` - Wrong parsing results from get_query_tables for select with UNION (by aborecki)
* 80 `bug` - Wrong parsing results get_query_tables for spaces in GROUP BY keyword (by aborecki)
* 81 `internals` - Use Poetry as dependency manager and PyPI publish tool
* 86 `dependencies` - build(deps-dev): bump pytest from 6.2.1 to 6.2.2 (by dependabot[bot])
* 87 `dependencies` - build(deps-dev): bump coverage from 5.3.1 to 5.4 (by dependabot[bot])
* 88 `internals` - Run tests on both Python 3.8 and 3.9
* 89 `internals` - Test with Python 3.7 too
* 90 `internals` - Improve CI cache handling
* 91 `internals` - Load cached Poetry venv
* 92 `internals` - Try to test using Python 3.6 and 3.7 too
* 93 `internals` - Tests - add code coverage report
* 94 `bug` - Union's don't return the correct result (by dylwylie)
* 95 `dependencies` - build(deps-dev): bump pylint from 2.6.0 to 2.6.2 (by dependabot[bot])
* 96 `pr` - Extend test coverage for UNION queries

Bug fixes

get_query_columns does not return nothing if parsing SELECT DISTINCT 72 (reported by benzzdan)
get_query_tables() CTE Case Sensitive for SELECT 71 (reported by nehalj12)

Other

Install black code formatter 63
build(deps-dev): bump coverage from 5.3 to 5.3.1 75
build(deps-dev): bump pytest from 6.2.0 to 6.2.1 74
build(deps-dev): bump pytest from 6.1.2 to 6.2.0 73
CI: cache pip dependencies 70
build(deps-dev): bump pytest from 6.1.1 to 6.1.2 69

sqlparse` - Remove debug print statement (https://github.com/andialbrecht/sqlparse/commit/ab53a4b25f853a79d63a6723efaf568b0be02711)

* Bump pytest from 6.0.1 to 6.0.2 62
* Bump coverage from 5.2.1 to 5.3 61
* build(deps-dev): bump pytest from 6.0.2 to 6.1.0 64
* `get_query_tables` doesn't respect table names with dashes in their name 60
* get_query_columns: improve handling of queries with "IS NULL" conditions 65
* build(deps-dev): bump pytest from 6.1.0 to 6.1.1 66
* build(deps): bump sqlparse from 0.3.1 to 0.4.0 67

* 38 `bug` - Ignoring Multiple FROM tables when they prefixed by DATASET (reported by rubensmussicury)
* 52 `bug` - Incorrect column names when table aliases are used (reported by akku1506 and fixed in 58)
* 55 `dependencies` - Bump coverage from 5.2 to 5.2.1 (by dependabot[bot])
* 56 `dependencies` - Bump pytest from 5.4.3 to 6.0.0 (by dependabot[bot])
* 57 `dependencies` - Bump pytest from 6.0.0 to 6.0.1 (by dependabot[bot])