What's Changed

Changes and new Features

• #2119 add support INSERT OVERWRITE PARTITION by @tt20061904 in https://github.com/JSQLParser/JSqlParser/pull/2135
• fix: allowing skyline keywords as columns, tables, etc. by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2137
• feat: Adding coverage for Postgres "OVERRIDING SYSTEM VALUE" by @nicky6s in https://github.com/JSQLParser/JSqlParser/pull/2142
• feat: Support unknown keyword by @EmilyOng in https://github.com/JSQLParser/JSqlParser/pull/2141
• Support not equals operator with a hat by @ssteinhauser in https://github.com/JSQLParser/JSqlParser/pull/2153
• Added support for minus all; except all; intersect all; by @SunandaS76 in https://github.com/JSQLParser/JSqlParser/pull/2081
• Add more tests to TablesNamesFinderTest for SubqueryAliasesIssue1987 by @pinkfloyda in https://github.com/JSQLParser/JSqlParser/pull/2154
• IsNullExpression and IsBooleanExpression children are not visited in … by @SuperPat45 in https://github.com/JSQLParser/JSqlParser/pull/2180
• Add support for parsing MySQL DISCARD and IMPORT TABLESPACE DDL statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2198
• Add support for AllTableColumns in PrimaryExpression by @tomershay in https://github.com/JSQLParser/JSqlParser/pull/2197
• Allow specific keywords to be parsed as identifiers (fix issue with RENAME COLUMN) by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2203
• Add support for MySQL ALTER TABLE ... [DEFAULT] COLLATE [=] collation_name syntax by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2204
• Add parsing for ALTER TABLE tbl_name {DISABLE | ENABLE} KEYS by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2205
• feat: add support SELECT all columns from function result by @0xlianhu in https://github.com/JSQLParser/JSqlParser/pull/2207
• feat: support MySQL ALTER TABLE ... PARTITION BY syntax by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2210
• Add support for MySQL ALTER TABLE partition options in parser by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2211
• Add test case for ALTER TABLE with KEY_BLOCK_SIZE for MySQL by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2213
• Add MySQL Index Parsing Support for ALTER TABLE Statements by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2215
• Resolve parser choice conflicts by adjusting lookahead in index-related rules by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2217
• Add support for TableFunction [WITH OFFSET|ORDINALITY] by @davyboyhayes in https://github.com/JSQLParser/JSqlParser/pull/2219
• Add support for parsing MySQL ALTER TABLE statements with advanced options by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2223
• feat: enhance ALTER TABLE support with UNIQUE KEY and INVISIBLE index by @minleejae in https://github.com/JSQLParser/JSqlParser/pull/2234

New Contributors

• @tt20061904 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2135
• @EmilyOng made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2141
• @SunandaS76 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2081
• @pinkfloyda made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2154
• @SuperPat45 made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2180
• @0xlianhu made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2207
• @davyboyhayes made their first contribution in https://github.com/JSQLParser/JSqlParser/pull/2219

Full Changelog: https://github.com/JSQLParser/JSqlParser/compare/jsqlparser-5.1...jsqlparser-5.2