Fix handling of the `ALTER TABLE ... ADD KEY` queries and logging fixes

What's Changed

• Bump black from 24.10.0 to 25.1.0 by @dependabot in #548
• Bump flake8 from 5.0.4 to 7.2.0 by @dependabot in #549
• Bump coverage from 6.5.0 to 7.8.0 by @dependabot in #547
• Bump pytest-cov from 5.0.0 to 6.1.1 by @dependabot in #550
• query_type: shorten the SQL query when logging the exception by @macbre in #552
• Fix handling of the ALTER TABLE ... ADD KEY queries by @macbre in #553

Full Changelog: v2.16.0...v2.17.0

Allow overriding `sqlparse.parse()` and drop support for Python 3.8

What's Changed

• Bump pytest from 8.3.3 to 8.3.4 by @dependabot in #533
• Bump sqlparse from 0.5.2 to 0.5.3 by @dependabot in #535
• Test using Python 3.13 + drop Python 3.8 by @macbre in #546
• Bump dependabot/fetch-metadata from 2.2.0 to 2.3.0 by @dependabot in #539
• Allow overriding sqlparse.parse() by @illes in #545

New Contributors

• @illes made their first contribution in #545 - thanks!

Full Changelog: v2.15.0...v2.16.0

sqlparse library updated

What's Changed

• Bump sqlparse from 0.5.1 to 0.5.2 by @dependabot in #531

Full Changelog: v2.14.0...v2.15.0

Fix the MSSQL Unqualified Schema Table Parsing

What's Changed

• Bump pylint from 3.2.6 to 3.2.7 by @dependabot in #524
• Bump pytest from 8.3.2 to 8.3.3 by @dependabot in #527
• Handle when column name wildcard is prefixed by table name #296 by @macbre in #330
• fixes #475 MSSQL Unqualified Schema Table Parsing by @T-Santos in #530

Full Changelog: v2.13.0...v2.14.0

Support the TRUNCATE TABLE query

Fixes and improvements

• Support for the TRUNCATE TABLE query parsing by @T-Santos in #521
• fix is_alias_without_as logical error by @MiuNice in #523

Dependencies

• Bump urllib3 from 1.26.18 to 1.26.19 by @dependabot in #501
• Bump pylint from 3.2.3 to 3.2.4 by @dependabot in #503
• Bump pylint from 3.2.4 to 3.2.5 by @dependabot in #504
• Bump dependabot/fetch-metadata from 2.1.0 to 2.2.0 by @dependabot in #505
• Bump certifi from 2023.7.22 to 2024.7.4 by @dependabot in #508
• Bump sqlparse from 0.5.0 to 0.5.1 by @dependabot in #511
• Bump pytest from 8.2.2 to 8.3.1 by @dependabot in #512
• Bump pylint from 3.2.5 to 3.2.6 by @dependabot in #513
• Bump pytest from 8.3.1 to 8.3.2 by @dependabot in #515
• Bump snok/install-poetry from 1.3.4 to 1.4.0 by @dependabot in #516
• Bump black from 24.4.2 to 24.8.0 by @dependabot in #517
• Bump snok/install-poetry from 1.4.0 to 1.4.1 by @dependabot in #518

New Contributors

• @T-Santos made their first contribution in #521, hi 👋🏻

Full Changelog: v2.12.0...v2.13.0

Support hive create function

What's Changed

• build(deps-dev): bump black from 24.4.0 to 24.4.1 by @dependabot in #483
• build(deps): bump dependabot/fetch-metadata from 2.0.0 to 2.1.0 by @dependabot in #484
• build(deps-dev): bump black from 24.4.1 to 24.4.2 by @dependabot in #485
• build(deps-dev): bump pytest from 8.1.1 to 8.2.0 by @dependabot in #486
• build(deps-dev): bump pylint from 3.1.0 to 3.1.1 by @dependabot in #488
• build(deps-dev): bump pylint from 3.1.1 to 3.2.0 by @dependabot in #489
• build(deps-dev): bump pytest from 8.2.0 to 8.2.1 by @dependabot in #491
• build(deps-dev): bump pylint from 3.2.0 to 3.2.1 by @dependabot in #492
• build(deps-dev): bump pylint from 3.2.1 to 3.2.2 by @dependabot in #493
• Bump pytest from 8.2.1 to 8.2.2 by @dependabot in #497
• Bump requests from 2.31.0 to 2.32.2 by @dependabot in #498
• Bump pylint from 3.2.2 to 3.2.3 by @dependabot in #499
• support hive create function by @MiuNice in #500

Full Changelog: v2.11.0...v2.12.0

ClickHouse: improved tokens handling

What's Changed

• ClickHouse: improved tokens handling by @darkydash in #450
• build(deps-dev): bump pylint from 3.0.2 to 3.0.3 by @dependabot in #455
• build(deps-dev): bump black from 23.11.0 to 23.12.0 by @dependabot in #456
• build(deps): bump actions/setup-python from 4 to 5 by @dependabot in #454
• build(deps-dev): bump black from 23.12.0 to 23.12.1 by @dependabot in #459
• build(deps-dev): bump pytest from 7.4.3 to 7.4.4 by @dependabot in #460
• Errors with syntax loop. by @MiuNice in #458
• Update _preprocess_query function in parser.py by @Samaha10 in #461
• build(deps-dev): bump pytest from 7.4.4 to 8.0.0 by @dependabot in #463
• build(deps): bump actions/cache from 3 to 4 by @dependabot in #462
• build(deps-dev): bump pytest from 8.0.0 to 8.0.1 by @dependabot in #466
• build(deps-dev): bump pytest from 8.0.1 to 8.0.2 by @dependabot in #470
• build(deps-dev): bump pylint from 3.0.3 to 3.1.0 by @dependabot in #471
• build(deps-dev): bump pytest from 8.0.2 to 8.1.0 by @dependabot in #472
• build(deps-dev): bump pytest from 8.1.0 to 8.1.1 by @dependabot in #473
• build(deps): bump dependabot/fetch-metadata from 1.6.0 to 2.0.0 by @dependabot in #476
• build(deps-dev): bump pytest-cov from 4.1.0 to 5.0.0 by @dependabot in #477
• build(deps-dev): bump idna from 3.4 to 3.7 by @dependabot in #479
• build(deps): bump sqlparse from 0.4.4 to 0.5.0 by @dependabot in #481
• build(deps-dev): bump black from 23.12.1 to 24.4.0 by @dependabot in #480

New Contributors

• @darkydash made their first contribution in #450
• @MiuNice made their first contribution in #458
• @Samaha10 made their first contribution in #461

Full Changelog: v2.10.0...v2.11.0

Improvements around parser.without_comments

What's Changed

• Fix #377 #390 #394 by @Byunk in #440
• build(deps-dev): bump pylint from 2.17.5 to 2.17.6 by @dependabot in #430
• build(deps-dev): bump pylint from 2.17.6 to 2.17.7 by @dependabot in #432
• build(deps-dev): bump pylint from 2.17.7 to 3.0.0 by @dependabot in #434
• build(deps-dev): bump urllib3 from 1.26.15 to 1.26.17 by @dependabot in #435
• Test using Python 3.12 by @macbre in #433
• build(deps-dev): bump pylint from 3.0.0 to 3.0.1 by @dependabot in #436
• build(deps-dev): bump urllib3 from 1.26.17 to 1.26.18 by @dependabot in #441
• build(deps-dev): bump black from 23.9.1 to 23.10.0 by @dependabot in #442
• build(deps-dev): bump pylint from 3.0.1 to 3.0.2 by @dependabot in #443
• build(deps-dev): bump black from 23.10.0 to 23.10.1 by @dependabot in #444
• build(deps-dev): bump pytest from 7.4.2 to 7.4.3 by @dependabot in #445
• build(deps-dev): bump black from 23.10.1 to 23.11.0 by @dependabot in #449

Full Changelog: v2.9.0...v2.10.0

Improved complex queries handling and support for NATURAL JOIN added

Fixes and new features

• Parser.tokens: ignore flake8 error by @macbre in #425
• Drop support for Python 3.7 by @macbre in #426
• Handle cases tables preceded by complex queries by @Byunk in #423
• Update keywords_lists.py by @at2706 in #428
• Update keywords_lists.py to add Natural Join by @lavkeshg in #403
• Add a test coverage for the NATURAL JOIN by @macbre in #429

New Contributors 👋🏻

• @Byunk made their first contribution in #423
• @at2706 made their first contribution in #428
• @lavkeshg made their first contribution in #403

Thanks!

Updated dependencies

• build(deps-dev): bump pylint from 2.17.2 to 2.17.3 by @dependabot in #389
• build(deps-dev): bump pylint from 2.17.3 to 2.17.4 by @dependabot in #393
• build(deps): bump dependabot/fetch-metadata from 1.4.0 to 1.5.0 by @dependabot in #395
• build(deps): bump requests from 2.28.2 to 2.31.0 by @dependabot in #396
• build(deps): bump dependabot/fetch-metadata from 1.5.0 to 1.5.1 by @dependabot in #398
• build(deps-dev): bump pytest-cov from 4.0.0 to 4.1.0 by @dependabot in #399
• build(deps-dev): bump pytest from 7.3.1 to 7.3.2 by @dependabot in #402
• build(deps-dev): bump pytest from 7.3.2 to 7.4.0 by @dependabot in #404
• build(deps): bump dependabot/fetch-metadata from 1.5.1 to 1.6.0 by @dependabot in #405
• build(deps-dev): bump pylint from 2.17.4 to 2.17.5 by @dependabot in #407
• build(deps): bump snok/install-poetry from 1.3.3 to 1.3.4 by @dependabot in #410
• build(deps-dev): bump pytest from 7.4.0 to 7.4.1 by @dependabot in #414
• build(deps-dev): bump pytest from 7.4.1 to 7.4.2 by @dependabot in #419
• build(deps-dev): bump certifi from 2022.12.7 to 2023.7.22 by @dependabot in #415
• build(deps): bump actions/checkout from 3 to 4 by @dependabot in #416
• build(deps-dev): bump black from 23.3.0 to 23.9.1 by @dependabot in #427

Full Changelog: v2.8.0...v2.9.0

Fixed handling of IN conditions and upsert queries

What's Changed

Bug fixes

• Fix handling of LIMIT / OFFSET in queries with the IN condition by @macbre in #387
• Properly support upsert queries when extracting table names by @macbre in #388

Others

• build(deps-dev): bump black from 23.1.0 to 23.3.0 by @dependabot in #379
• build(deps-dev): bump pylint from 2.17.1 to 2.17.2 by @dependabot in #380
• build(deps-dev): bump pytest from 7.2.2 to 7.3.0 by @dependabot in #381
• build(deps-dev): bump pytest from 7.3.0 to 7.3.1 by @dependabot in #383
• build(deps): bump dependabot/fetch-metadata from 1.3.6 to 1.4.0 by @dependabot in #385
• build(deps): bump sqlparse from 0.4.3 to 0.4.4 by @dependabot in #386

Full Changelog: v2.7.0...v2.8.0