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