What's Changed

• Fix parsing of a parenthesized left operand of a set operator by @therealpandey in #312

Full Changelog: v0.5.5...v0.5.6

What's Changed

• Derive the CLI version from build info instead of a constant by @git-hulk in #300
• Fix should allow END as a bare column name by @erezrokah in #301
• Fix parsing of HTTP dictionary sources by @vincentbernat in #302
• Add support for ALTER TABLE ... MODIFY ORDER BY by @vincentbernat in #303
• Allow any expression as the value of CAST by @vincentbernat in #304
• fix: Accept reserved keyword as expression operand by @erezrokah in #305
• Add support for DROP DATABASE ... SYNC by @vincentbernat in #309
• Add support for SYSTEM RELOAD DICTIONARY ... ON CLUSTER by @vincentbernat in #308
• Reject a trailing operator instead of dropping it at end of input by @git-hulk in #306
• Allow CAST as a table function argument by @git-hulk in #307

New Contributors

• @vincentbernat made their first contribution in #302

Full Changelog: v0.5.4...v0.5.5

What's Changed

• Add support to understand the GCD codec by @mdevilliers in #288
• Support SQL-standard keyword arguments for trim, substring, overlay and overlayUTF8 by @therealpandey in #290
• Fix parsing of the GLOBAL/LOCAL join locality and GLOBAL NOT IN by @therealpandey in #293
• Merge join locality parsing into parseJoinModifiers by @git-hulk in #295
• Fix parsing of operator expressions in table function arguments by @therealpandey in #298
• Fix parsing of an unquoted interval as a column name by @therealpandey in #296

Full Changelog: v0.5.3...v0.5.4

What's Changed

• Fix signed number after ')' or ']' being lexed as a literal by @therealpandey in #287

New Contributors

• @therealpandey made their first contribution in #287

Full Changelog: v0.5.2...v0.5.3

What's Changed

• Ensure projections can have either an order by or a group by by @mdevilliers in #266
• Add support of REGEXP as binary operator by @erezrokah in #267
• Fix should allow trailing comma in SELECT list before clause keyword by @erezrokah in #268
• Allow reserved keywords as bare column names in SELECT list by @erezrokah in #269
• Fix should allow column list before ENGINE in CREATE MATERIALIZED VIEW by @sharadgaur in #270
• Fix nil-pointer dereference when formatting errors at EOF by @git-hulk in #273
• Fix infinite loop (DoS hang) on unterminated block comment by @git-hulk in #271
• Fix index-out-of-range panic in wrapError at EOF by @git-hulk in #272
• Add structured ParseError with O(log n) position lookup by @git-hulk in #274
• Add drift test keeping ASTVisitor and Walk traversals in sync by @git-hulk in #276
• Rename lexer state to match what it holds by @git-hulk in #277
• Fix expression precedence for lambda, ternary and NOT operators by @git-hulk in #279
• Fix number lexing, unterminated block comments and non-ASCII bytes by @git-hulk in #280
• Fix position tracking across ratio, IS NULL, GROUP BY, ALTER and dictionary nodes by @git-hulk in #283
• Split keywords into reserved and non-reserved sets by @git-hulk in #282
• Fix Accept/Walk field-level drift and InsertStmt End() panic by @git-hulk in #284
• Fix traversal of semantic AST children by @git-hulk in #285

Full Changelog: v0.5.1...v0.5.2

What's Changed

• Add support for window names in WindowExpr by @chinhnguyenh in #259
• Fix panic on invalid number as query, add guard against invalid lastToken by @disq in #260
• Support COMMENT before AS SELECT in CREATE MATERIALIZED VIEW by @sharadgaur in #262
• Add support for CREATE USER VALID UNTIL clause by @git-hulk in #264
• feat: add COMMENT support to CREATE VIEW parser by @sharadgaur in #265

New Contributors

• @chinhnguyenh made their first contribution in #259

Full Changelog: v0.5.0...v0.5.1

What's Changed

• Add support for nested named/unnamed tuple types by @rhino1998 in #233
• Add support for CREATE NAMED COLLECTION statements (#235) by @St0rmPetrel in #236
• Add line break and indentation to FROM clause formatting by @Copilot in #244
• Add line break before column list in INSERT INTO formatting by @Copilot in #246
• Add line break and indentation for SETTINGS clause in beautify mode by @Copilot in #245
• Add beautify format support for CREATE USER statements by @Copilot in #247
• Add chaining methods to formatter for customizable indentation by @Copilot in #248
• Document -beautify flag with example by @Copilot in #249
• Add line breaks for ON CLUSTER and ALTER clauses in beautify mode by @Copilot in #251
• Add beautify format support for CREATE DICTIONARY statements by @Copilot in #253
• fix: support expressions (dotted column refs) in DISTINCT ON by @disq in #258

New Contributors

• @St0rmPetrel made their first contribution in #236
• @disq made their first contribution in #258

Full Changelog: v0.4.19...v0.5.0

What's Changed

• Add support for OFFSET clause without LIMIT by @rhino1998 in #226
• Fix workflow does not contain permissions by @git-hulk in #227
• Add support for concat operator by @rhino1998 in #228
• Fix support for multiple array join statements by @hermanschaaf in #229
• Allow ARRAY JOIN to be interleaved with other JOIN statements by @hermanschaaf in #230
• Fix CASE statement WHEN spacing by @rhino1998 in #231
• Add support for SETTINGS clause in ALTER TABLE ADD COLUMN by @Lance726 in #232
• Fix parsing failure when having multiple ttl expressions by @git-hulk in #234

New Contributors

• @rhino1998 made their first contribution in #226
• @hermanschaaf made their first contribution in #229

Full Changelog: v0.4.18...v0.4.19

What's Changed

• Fix efreshable View with named parameters by @sharadgaur in #217
• Fix Send error messages to stderr instead of stdout by @Copilot in #221
• Fix regex expression wasn't allowed in EXTRACT by @git-hulk in #223
• Support empty parentheses in index type definitions by @Lance726 in #224
• Add support for parsing Tuple type in DDL by @git-hulk in #225

Full Changelog: v0.4.17...v0.4.18

What's Changed

• Fix string escape sequences in lexer by @waterdrag0n in #209
• Add COMMENT support for CREATE DICTIONARY DDL statements by @sharadgaur in #210
• Add WITH FILL Support in ORDER BY by @Flo4604 in #211
• Parse compression codecs with no parameters by @swgillespie in #197
• Fix nil pointer for replicated database engine by @rabenhorst in #212
• Add support of parsing SETTING boolean values by @mdevilliers in #213
• Add support for table functions in CREATE TABLE AS statements by @swgillespie in #214
• Fix a crash with an invalid query following MODIFY QUERY by @swgillespie in #215

New Contributors

• @waterdrag0n made their first contribution in #209
• @Flo4604 made their first contribution in #211
• @swgillespie made their first contribution in #197
• @rabenhorst made their first contribution in #212
• @mdevilliers made their first contribution in #213

Full Changelog: v0.4.15...v0.4.17