0.19.3

What's Changed

• [Timestamp] Fix TIMESTAMP_TRUNC for SECONDS and MILLISECONDS by @Zherdev in #219
• Fix control flow execution of conditional functions IF(), IFNULL() by @ohaibbq in #216
• Support create table as select with column list by @ohaibbq in #214

New Contributors

• @Zherdev made their first contribution in #219

Full Changelog: v0.19.2...v0.19.3

0.19.2

What's Changed

• Update linter by @goccy in #189
• Implement dayOfYearParser by @recidinick in #197
• Support PIVOT / UNPIVOT by @ohaibbq in #198
• Support sql.Driver's PrepareContext interface by @ohaibbq in #203
• Fix QueryStmtNode output; wrap union statements in parentheses by @ohaibbq in #205
• Support UNNEST WITH OFFSET by @ohaibbq in #199
• Enable QUALIFY without GROUP BY / WHERE / HAVING by @ohaibbq in #201
• [Date] [Datetime] [Timestamp] Handle QUARTER, WEEK(DAY), ISOWEEK by @ohaibbq in #204

New Contributors

• @recidinick made their first contribution in #197

Full Changelog: v0.19.1...v0.19.2

0.19.1

What's Changed

• [Filter] Fix syntax error that occurred for some queries using subselects or QUALIFY by @ohaibbq in #157
• [Windowing] [Formatter] Reset format context in-between analytic function groups by @ohaibbq in #162
• [Aggregate] Correctly handle ordering multiple fields; don't crash on nil by @ohaibbq in #174
• Harden string functions when NULL is passed by @colincadams in #112
• [Date] Implement %p, improve token composition, fix leading-space parsers/formatters, improve error messages, slurp whitespace by @ohaibbq in #166
• [String] Do not cast integer/float-like strings to datetime by @ohaibbq in #184

Full Changelog: v0.19.0...v0.19.1

0.19.0

What's Changed

• [Testing] Use UTC timezone in query_test.go by @ohaibbq in #131
• [Timestamp] Use microsecond precision to support full range of BigQuery timestamps by @ohaibbq in #133
• [Date] Base date used when parsing is start of unix time, not 0001-01-01 by @ohaibbq in #143
• [Windowing] Handle multiple sort expressions by @ohaibbq in #142
• [Date] Implement %y year without century parser / formatter; respect digits that are below maximum format length by @ohaibbq in #135
• Dont crash on nil in LOGICAL_OR and LOGICAL_AND by @ohaibbq in #187
• Use value comparators for LEAST, GREATEST, BETWEEN by @ohaibbq in #182
• [String] Use direct string value from ZetaSQL by @ohaibbq in #183
• [Array] Handle null ARRAY fields by @ohaibbq in #181
• [Array] Support LEFT OUTER / INNER JOIN modes by @ohaibbq in #180
• Fix IN() operator return when left-hand side is null by @ohaibbq in #173
• [Functions] Fix NULLIF panic on null by @ohaibbq in #164
• [Aggregate] Properly return nil for STRING_AGG when called with null or 0-length array by @ohaibbq in #154
• [Array] Fix ordinal boundary indexing by @ohaibbq in #155
• [String] LIKE properly escapes regexp-characters by @ohaibbq in #156
• [Driver] Fix prepared insert statements raising not enough query arguments by @ohaibbq in #171
• [String] Cast to INT64 should use base-10 parsing by @ohaibbq in #159

New Contributors

• @ohaibbq made their first contribution in #131

Full Changelog: v0.18.0...v0.19.0

0.18.0

What's Changed

• DATE_DIFF fix for days and months by @kberezin-nshl in #124
• Update PERCENTILE_CONT to handle non-zero minimum value by @heyweswu in #120
• Handle JSON-Null values in JSON functions by @beckerhe in #122
• Support DROP VIEW statement by @goccy in #128
• Update dependencies by @goccy in #129

New Contributors

• @kberezin-nshl made their first contribution in #124
• @heyweswu made their first contribution in #120
• @beckerhe made their first contribution in #122

Full Changelog: v0.17.3...v0.18.0

0.17.3

What's Changed

• Update dependencies by @goccy in #127

Full Changelog: v0.17.2...v0.17.3

0.17.2

What's Changed

• Fix issue with passing parameters to a multiple statements SQL query by @totem3 in #119

New Contributors

• @totem3 made their first contribution in #119

Full Changelog: v0.17.1...v0.17.2

0.17.1

What's Changed

• Care INFORMATION_SCHEMA by @goccy in #118

Full Changelog: v0.17.0...v0.17.1

0.17.0

What's Changed

• Support SetMaxNamePath API by @goccy in #117

Full Changelog: v0.16.0...v0.17.0

0.16.0

What's Changed

• Support precision in ROUND by @amcgavin in #114
• Support API to get changed catalogs by @goccy in #116
• Implement timePrecisionParser by @hrkskov in #115

New Contributors

• @amcgavin made their first contribution in #114

Full Changelog: v0.15.0...v0.16.0