Sql-metadata

What's Changed
* build(deps): bump actions/cache from 2 to 3 by dependabot in https://github.com/macbre/sql-metadata/pull/299
* build(deps-dev): bump pylint from 2.12.2 to 2.13.0 by dependabot in https://github.com/macbre/sql-metadata/pull/300
* build(deps-dev): bump pylint from 2.13.0 to 2.13.2 by dependabot in https://github.com/macbre/sql-metadata/pull/301
* build(deps-dev): bump black from 22.1.0 to 22.3.0 by dependabot in https://github.com/macbre/sql-metadata/pull/302
* build(deps-dev): bump pylint from 2.13.2 to 2.13.3 by dependabot in https://github.com/macbre/sql-metadata/pull/303
* build(deps-dev): bump pylint from 2.13.3 to 2.13.4 by dependabot in https://github.com/macbre/sql-metadata/pull/304
* build(deps-dev): bump pylint from 2.13.4 to 2.13.5 by dependabot in https://github.com/macbre/sql-metadata/pull/305
* build(deps-dev): bump pylint from 2.13.5 to 2.13.7 by dependabot in https://github.com/macbre/sql-metadata/pull/307
* build(deps): bump dependabot/fetch-metadata from 1.3.0 to 1.3.1 by dependabot in https://github.com/macbre/sql-metadata/pull/308
* Do not consider `AS (` from window clause as query start by vakhmenin in https://github.com/macbre/sql-metadata/pull/310
* Add next_token_not_comment property of Token by vakhmenin in https://github.com/macbre/sql-metadata/pull/312

New Contributors
* vakhmenin made their first contribution in https://github.com/macbre/sql-metadata/pull/310

**Full Changelog**: https://github.com/macbre/sql-metadata/compare/v2.4.0...v2.5.0

What's Changed
* build(deps-dev): bump pylint from 2.10.2 to 2.11.1 by dependabot in https://github.com/macbre/sql-metadata/pull/237
* build(deps-dev): bump black from 21.8b0 to 21.9b0 by dependabot in https://github.com/macbre/sql-metadata/pull/235
* Ignore failed coverage uploads to Coveralls by macbre in https://github.com/macbre/sql-metadata/pull/239
* Add interactive demo link to README by dylanhogg in https://github.com/macbre/sql-metadata/pull/241
* build(deps-dev): bump pytest-cov from 2.12.1 to 3.0.0 by dependabot in https://github.com/macbre/sql-metadata/pull/244
* build(deps-dev): bump flake8 from 3.9.2 to 4.0.1 by dependabot in https://github.com/macbre/sql-metadata/pull/246
* CI - add Python 3.10 by macbre in https://github.com/macbre/sql-metadata/pull/106
* With in join fix by collerek in https://github.com/macbre/sql-metadata/pull/249
* add insert to with ending keywords by collerek in https://github.com/macbre/sql-metadata/pull/250
* build(deps-dev): bump black from 21.9b0 to 21.10b0 by dependabot in https://github.com/macbre/sql-metadata/pull/252
* build(deps-dev): bump coveralls from 3.2.0 to 3.3.0 by dependabot in https://github.com/macbre/sql-metadata/pull/254
* build(deps-dev): bump coverage from 5.5 to 6.1.1 by dependabot in https://github.com/macbre/sql-metadata/pull/256
* build(deps-dev): bump coverage from 6.1.1 to 6.1.2 by dependabot in https://github.com/macbre/sql-metadata/pull/257
* build(deps-dev): bump coveralls from 3.3.0 to 3.3.1 by dependabot in https://github.com/macbre/sql-metadata/pull/258
* build(deps): bump actions/setup-python from 2.2.2 to 2.3.0 by dependabot in https://github.com/macbre/sql-metadata/pull/264
* build(deps-dev): bump black from 21.10b0 to 21.11b1 by dependabot in https://github.com/macbre/sql-metadata/pull/265
* build(deps): bump snok/install-poetry from 1.2 to 1.3 by dependabot in https://github.com/macbre/sql-metadata/pull/266
* build(deps-dev): bump pylint from 2.11.1 to 2.12.1 by dependabot in https://github.com/macbre/sql-metadata/pull/267
* build(deps-dev): bump coverage from 6.1.2 to 6.2 by dependabot in https://github.com/macbre/sql-metadata/pull/268
* build(deps): bump actions/setup-python from 2.3.0 to 2.3.1 by dependabot in https://github.com/macbre/sql-metadata/pull/269
* build(deps-dev): bump pylint from 2.12.1 to 2.12.2 by dependabot in https://github.com/macbre/sql-metadata/pull/272
* build(deps-dev): bump black from 21.11b1 to 21.12b0 by dependabot in https://github.com/macbre/sql-metadata/pull/273
* Add `USING` to column keywords by glentakahashi in https://github.com/macbre/sql-metadata/pull/255
* Adds DELETE as a supported query type by Governa in https://github.com/macbre/sql-metadata/pull/271
* Allow using keyword as table alias by niyue in https://github.com/macbre/sql-metadata/pull/278
* Add cross join to list of keywords by Jedi18 in https://github.com/macbre/sql-metadata/pull/281
* build(deps-dev): bump black from 21.12b0 to 22.1.0 by dependabot in https://github.com/macbre/sql-metadata/pull/283
* build(deps-dev): bump pytest from 6.2.5 to 7.0.0 by dependabot in https://github.com/macbre/sql-metadata/pull/286
* build(deps): bump actions/setup-python from 2.3.1 to 2.3.2 by dependabot in https://github.com/macbre/sql-metadata/pull/287
* build(deps-dev): bump pytest from 7.0.0 to 7.0.1 by dependabot in https://github.com/macbre/sql-metadata/pull/288
* build(deps): bump dependabot/fetch-metadata from 1.1.1 to 1.2.0 by dependabot in https://github.com/macbre/sql-metadata/pull/289
* build(deps): bump dependabot/fetch-metadata from 1.2.0 to 1.2.1 by dependabot in https://github.com/macbre/sql-metadata/pull/290
* build(deps): bump dependabot/fetch-metadata from 1.2.1 to 1.3.0 by dependabot in https://github.com/macbre/sql-metadata/pull/293
* build(deps): bump actions/setup-python from 2.3.2 to 3 by dependabot in https://github.com/macbre/sql-metadata/pull/292
* build(deps): bump actions/checkout from 2 to 3 by dependabot in https://github.com/macbre/sql-metadata/pull/294

New Contributors
* glentakahashi made their first contribution in https://github.com/macbre/sql-metadata/pull/255
* Governa made their first contribution in https://github.com/macbre/sql-metadata/pull/271
* niyue made their first contribution in https://github.com/macbre/sql-metadata/pull/278
* Jedi18 made their first contribution in https://github.com/macbre/sql-metadata/pull/281

Hi and thanks, folks!

**Full Changelog**: https://github.com/macbre/sql-metadata/compare/v2.3.0...v2.4.0

* 187 `internals` - Multi from aliases (by collerek)
* 188 `bug` - Query including Distinct not working
* 189 `dependencies` - build(deps-dev): bump black from 21.6b0 to 21.7b0 (by dependabot[bot])
* 190 `internals` - CI - install the latest black version
* 192 `dependencies` - build(deps-dev): bump pylint from 2.9.3 to 2.9.4 (by dependabot[bot])
* 193 `dependencies` - build(deps-dev): bump coveralls from 3.1.0 to 3.2.0 (by dependabot[bot])
* 194 `pr` - Fix for Casting values results in incorrect alias reporting (by collerek)
* 195 `dependencies` - build(deps-dev): bump pylint from 2.9.5 to 2.9.6 (by dependabot[bot])
* 203 `pr` - Ignore case on column alias names from subquery (by christopherpickering)
* 211 `internals` - snok/install-poetry - use a default Poetry version
* 216 `dependencies` - build(deps-dev): bump pylint from 2.9.6 to 2.10.2 (by dependabot[bot])
* 217 `internals` - Extract conditions (by collerek)
* 218 `dependencies` - build(deps-dev): bump black from 21.7b0 to 21.8b0 (by dependabot[bot])
* 219 `dependencies` - build(deps-dev): bump pytest from 6.2.4 to 6.2.5 (by dependabot[bot])
* 222 `pr` - Restore fully qualified columns (by collerek)
* 223 `pr` - fix recurrent aliases names leading to infinite loop (by collerek)
* 228 `pr` - allow redundant parentheses around (sub)queries (by collerek)
* 229 `pr` - additional test for cast (by collerek)
* 230 `dependencies` - build(deps): bump sqlparse from 0.4.1 to 0.4.2 (by dependabot[bot])

Welcome, christopherpickering, as our new contributor 🙂

This release of `sql-metadata` brings even further improvement of handling of `with` and table creation statements. We also keep up to date with our dependencies and improving CI pipeline.

build(deps-dev): bump black from 21.5b2 to 21.6b0 167
Fix create schema 171
Create table with schema detects field names as tables 168
Fix for nested with statements in select 173
CI - install Poetry 1.1.7 174
build(deps-dev): bump pylint from 2.8.3 to 2.9.0 178
nested with statement causes confusion 172
build(deps-dev): bump pylint from 2.9.0 to 2.9.1 179
build(deps-dev): bump pylint from 2.9.1 to 2.9.3 180

This minor release brings two fixes:

* 162 `bug` - Fix parsing with clauses, fix for 161 (by collerek)
* 164 `bug` - Handle leading comments in queries (by macbre)

This release of `sql-metadata` brings **improved handling of subqueries** (thanks 154) and of **`CREATE TABLE` queries containing a `WITH` clause** (157).

As an internal change improving our development **Coveralls has been introduced that tracks code coverage** of this project (159).

As always we're staying up to date with various dependencies.

Changelog

* 151 `dependencies` - build(deps-dev): bump pylint from 2.8.2 to 2.8.3 (by dependabot[bot])
* 152 `dependencies` - build(deps-dev): bump black from 21.5b1 to 21.5b2 (by dependabot[bot])
* 153 `dependencies` - Update black to 21.5b2
* 154 `enhancement` - Resolving subqueries columns (by collerek)
* 155 `bug` - The tables property is still having difficulties finding the tables in a CTAS (by tipanverella)
* 156 `dependencies` - build(deps-dev): bump pytest-cov from 2.12.0 to 2.12.1 (by dependabot[bot])
* 157 `bug` - Fix for create table with with clause (by collerek)
* 158 `internals` - Automerge dependabot pull requests
* 159 `internals` - Upload coverage report to Coveralls