What's Changed

Changes and new Features

• Avoid private tokens to be white listed and allow any word character in token value by @ssteinhauser in #2044
• Resolve parsing error for CHARACTER SET and COLLATE in MySQL ALTER TABLE (issue 2027) by @minleejae in #2045
• fix truncate parsing to capture multiple tables by @nick-redfearn in #2048
• fix insert default values statements not parsing by @nicky6s in #2050
• chore adding extra details to unit test scenarios by @nicky6s in #2051
• feature/fix: parsing inserts/updates/delete within CTEs by @nicky6s in #2055
• chore removing system.out.println lines + minor clean up of unit test scripts by @nicky6s in #2060
• Exasol support by @ssteinhauser in #2046
• Unparenthesized SubSelect as FromItem by @ssteinhauser in #2073
• Skyline syntax (preferring clause) by @ssteinhauser in #2078
• Failure to parse query with PRIOR in select list by @hannes92 in #2083
• Fix parsing ALTER TABLE ... ADD COLUMNS (...) by @njaremko in #2087
• Fix issue 2090: Correctly parse LOCK clause in ALTER TABLE statements by @minleejae in #2095
• Fix issue 2089: Add parsing functionality for MySQL CONVERT TO statement by @minleejae in #2097
• Fix issue 2106: Add parsing functionality for MySQL ADD PARTITION and DROP PARTITION clauses in ALTER TABLE statements by @minleejae in #2107
• Fix issue 2106: Add parsing functionality for MySQL ADD PARTITION and DROP PARTITION clauses in ALTER TABLE statements(2) by @minleejae in #2108
• fix: Issue #2109 true and false value parsed as column instead of BooleanValue by @lucarota in #2110
• Fix issue 2106: Add parsing functionality for MySQL ALTER Table option statements by @minleejae in #2115
• Fix issue 2089: Enhance MySQL CONVERT Statement Parsing by @minleejae in #2117
• Fix issue 2118: Enhance MySQL ALTER TABLE Parsing by @minleejae in #2121
• fix: [FEATURE] TablesNamesFinder does not support CREATE VIEW #2123 by @cptnricard in #2124
• add support for MATERIALIZED in WITH clause by @tomershay in #2128
• feat: add support MATCH_ANY MATCH_ALL MATCH_PHRASE MATCH_PHRASE_PREFIX MATCH_REGEXP by @dengliming in #2132
• build(deps): bump org.junit.jupiter:junit-jupiter-engine from 5.11.3 to 5.11.4 by @dependabot in #2129
• Fix null exception in ExpressionVisitorAdapter with simple INTERVAL expression by @tomershay in #2133

New Contributors

• @ssteinhauser made their first contribution in #2044
• @minleejae made their first contribution in #2045
• @nick-redfearn made their first contribution in #2048
• @nicky6s made their first contribution in #2050
• @hannes92 made their first contribution in #2083
• @njaremko made their first contribution in #2087
• @cptnricard made their first contribution in #2124
• @dengliming made their first contribution in #2132

Full Changelog: jsqlparser-5.0...jsqlparser-5.1