v0.18.0-recidiviz.9

What's Changed

• [trim] trim all whitespace by default, not just spaces by @ethan-oro in #47
• Fix control flow execution of conditional functions IF(), IFNULL() by @ohaibbq in #46

New Contributors

• @ethan-oro made their first contribution in #47

Full Changelog: v0.18.0-recidiviz.8...v0.18.0-recidiviz.9

v0.18.0-recidiviz.8

What's Changed

• Support PIVOT / UNPIVOT by @ohaibbq in #36
• Support UNNEST WITH OFFSET by @ohaibbq in #37
• Enable QUALIFY without GROUP BY / WHERE / HAVING by @ohaibbq in #38
• [Window] Support LOGICAL_OR and LOGICAL_AND by @ohaibbq in #42
• Fix QueryStmtNode output; wrap union statements in parentheses by @ohaibbq in #41
• Support sql.Driver's PrepareContext interface by @ohaibbq in #40
• [Date] [Datetime] [Timestamp] Handle QUARTER, WEEK(DAY), ISOWEEK by @ohaibbq in #39
• Allow users of the driver to disable query formatting; support named parameters in QueryStmt, DMLStmt by @ohaibbq in #43
• Support CONTAINS_SUBSTR function by @ohaibbq in #45
• Use WITHOUT ROWID table clustering for primary keys by @ohaibbq in #44

Full Changelog: v0.18.0-recidiviz.7...v0.18.0-recidiviz.8

v0.18.0-recidiviz.7

What's Changed

• Parse julian day of year in PARSE_DATE and PARSE_DATETIME by @recidinick in #35

New Contributors

• @recidinick made their first contribution in #35

Full Changelog: v0.18.0-recidiviz.6...v0.18.0-recidiviz.7

v0.18.0-recidiviz.6

What's Changed

• Dont crash on nil in LOGICAL_OR and LOGICAL_AND by @ohaibbq in #34

Full Changelog: v0.18.0-recidiviz.5...v0.18.0-recidiviz.6

v0.18.0-recidiviz.5

What's Changed

• Return nil for null values in IN(), BETWEEN(), AND LIKE() by @ohaibbq in #31
• Materialize CTEs for faster execution by @ohaibbq in #32
• Ignore nulls when counting window values by @ohaibbq in #33

Full Changelog: v0.18.0-recidiviz.4...v0.18.0-recidiviz.5

v0.18.0-recidiviz.4

What's Changed

• Fix IN() operator return when left-hand side is null by @ohaibbq in #22
• [Date Parser] Capture all whitespace when processing whitespace format elements by @ohaibbq in #23
• [Date Parser] Fix %p 12pm case by @ohaibbq in #24
• [Aggregate] Correctly handle ordering multiple fields; dont crash on nil by @ohaibbq in #25
• [Array] Support LEFT OUTER / INNER JOIN modes by @ohaibbq in #26
• [Array] Handle null ARRAY fields by @ohaibbq in #27
• Use value comparators for LEAST, GREATEST, BETWEEN by @ohaibbq in #28
• [String] Do not cast integer/float-like strings to datetime by @ohaibbq in #30
• [String] Use direct string value from ZetaSQL by @ohaibbq in #29

Full Changelog: v0.18.0-recidiviz.3...v0.18.0-recidiviz.4

v0.18.0-recidiviz.3

What's Changed

• [Driver] Fix prepared insert statements raising not enough query arguments by @ohaibbq in #21
• [Windowing] Rewrite window function implementation to use real SQLite windows by @ohaibbq in #20

Full Changelog: v0.18.0-recidiviz.2...v0.18.0-recidiviz.3

v0.18.0-recidiviz.2

What's Changed

• [Aggregate] Properly return nil for STRING_AGG when called with null or 0-length array by @ohaibbq in #12
• [Array] Fix ordinal boundary indexing by @ohaibbq in #13
• [String] LIKE properly escapes regexp-characters by @ohaibbq in #14
• [Filter] Fix syntax error that occurred for some queries using subselects or QUALIFY by @ohaibbq in #15
• [Date] Implement %p, improve token composition, fix leading-space parsers/formatters by @ohaibbq in #19
• [Functions] Fix NULLIF panic on null by @ohaibbq in #18
• [Windowing] [Formatter] Reset format context in-between analytic function groups by @ohaibbq in #17
• [String] Cast to INT64 should use base-10 parsing by @ohaibbq in #16

Full Changelog: v0.18.0-recidiviz.1...v0.18.0-recidiviz.2

v0.18.0-recidiviz.1

What's Changed

• [Testing] Use UTC timezone in query_test.go by @ohaibbq in #6
• [Timestamp] Use microsecond precision to support full range of BigQuery timestamps by @ohaibbq in #7
• [Date] Base date used when parsing is start of unix time, not 0001-01-01 by @ohaibbq in #11
• [Windowing] Handle null values in partitions by @ohaibbq in #9
• [Date] Implement %y year without century parser / formatter; handle incomplete digits by @ohaibbq in #8
• [Windowing] Handle multiple sort expressions by @ohaibbq in #10

New Contributors

• @ohaibbq made their first contribution in #6

Full Changelog: v0.18.0-recidiviz.0...v0.18.0-recidiviz.1

v0.18.0-recidiviz.0

Rebased with latest