go-zetasqlite

What's Changed

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

New Contributors

• @recidinick made their first contribution in https://github.com/goccy/go-zetasqlite/pull/197

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.19.1...v0.19.2

What's Changed

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

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.19.0...v0.19.1

What's Changed

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

New Contributors

• @ohaibbq made their first contribution in https://github.com/goccy/go-zetasqlite/pull/131

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.18.0...v0.19.0

What's Changed

• DATE_DIFF fix for days and months by @kberezin-nshl in https://github.com/goccy/go-zetasqlite/pull/124
• Update PERCENTILE_CONT to handle non-zero minimum value by @heyweswu in https://github.com/goccy/go-zetasqlite/pull/120
• Handle JSON-Null values in JSON functions by @beckerhe in https://github.com/goccy/go-zetasqlite/pull/122
• Support DROP VIEW statement by @goccy in https://github.com/goccy/go-zetasqlite/pull/128
• Update dependencies by @goccy in https://github.com/goccy/go-zetasqlite/pull/129

New Contributors

• @kberezin-nshl made their first contribution in https://github.com/goccy/go-zetasqlite/pull/124
• @heyweswu made their first contribution in https://github.com/goccy/go-zetasqlite/pull/120
• @beckerhe made their first contribution in https://github.com/goccy/go-zetasqlite/pull/122

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.17.3...v0.18.0

What's Changed

• Update dependencies by @goccy in https://github.com/goccy/go-zetasqlite/pull/127

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.17.2...v0.17.3

What's Changed

• Fix issue with passing parameters to a multiple statements SQL query by @totem3 in https://github.com/goccy/go-zetasqlite/pull/119

New Contributors

• @totem3 made their first contribution in https://github.com/goccy/go-zetasqlite/pull/119

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.17.1...v0.17.2

What's Changed

• Care INFORMATION_SCHEMA by @goccy in https://github.com/goccy/go-zetasqlite/pull/118

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.17.0...v0.17.1

What's Changed

• Support SetMaxNamePath API by @goccy in https://github.com/goccy/go-zetasqlite/pull/117

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.16.0...v0.17.0

What's Changed

• Support precision in ROUND by @amcgavin in https://github.com/goccy/go-zetasqlite/pull/114
• Support API to get changed catalogs by @goccy in https://github.com/goccy/go-zetasqlite/pull/116
• Implement timePrecisionParser by @hrkskov in https://github.com/goccy/go-zetasqlite/pull/115

New Contributors

• @amcgavin made their first contribution in https://github.com/goccy/go-zetasqlite/pull/114

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.15.0...v0.16.0

What's Changed

• Support Net functions by @logicoffee in https://github.com/goccy/go-zetasqlite/pull/99
• Update CLI by @goccy in https://github.com/goccy/go-zetasqlite/pull/107

New Contributors

• @logicoffee made their first contribution in https://github.com/goccy/go-zetasqlite/pull/99

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.14.1...v0.15.0

What's Changed

• Fix base value of strconv.ParseInt by @goccy in https://github.com/goccy/go-zetasqlite/pull/105
• Fix EXTRACT for timestamp value by @goccy in https://github.com/goccy/go-zetasqlite/pull/106

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.14.0...v0.14.1

What's Changed

• Update readme by @marcellustavares in https://github.com/goccy/go-zetasqlite/pull/94
• Insert Select statement support by @marcellustavares in https://github.com/goccy/go-zetasqlite/pull/93
• Implement DATE_DIFF by week by @marcosapmf in https://github.com/goccy/go-zetasqlite/pull/91
• Fix array function format by @hrkskov in https://github.com/goccy/go-zetasqlite/pull/95
• Add timezone parser for 'Ez' format by @hrkskov in https://github.com/goccy/go-zetasqlite/pull/92
• Add time format by @goccy in https://github.com/goccy/go-zetasqlite/pull/97
• fix TABLE_SUFFIX query by @hrkskov in https://github.com/goccy/go-zetasqlite/pull/96
• Suppress errors when SQL functions have SAFE. prefix by @colincadams in https://github.com/goccy/go-zetasqlite/pull/98
• Update sqlite3 by @goccy in https://github.com/goccy/go-zetasqlite/pull/100
• Fix window order by @goccy in https://github.com/goccy/go-zetasqlite/pull/101
• Fix DATE_ADD/SUB DATETIME_ADD/SUB by @goccy in https://github.com/goccy/go-zetasqlite/pull/102
• Improve CI by @goccy in https://github.com/goccy/go-zetasqlite/pull/103
• Update Go version to 1.18 by @goccy in https://github.com/goccy/go-zetasqlite/pull/104

New Contributors

• @marcosapmf made their first contribution in https://github.com/goccy/go-zetasqlite/pull/91
• @hrkskov made their first contribution in https://github.com/goccy/go-zetasqlite/pull/95
• @colincadams made their first contribution in https://github.com/goccy/go-zetasqlite/pull/98

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.5...v0.14.0

What's Changed

• Implement DATE_TRUNC by day by @marcellustavares in https://github.com/goccy/go-zetasqlite/pull/87
• Update functionality of COALESCE to match zetasql by @nsfinkelstein in https://github.com/goccy/go-zetasqlite/pull/88

New Contributors

• @nsfinkelstein made their first contribution in https://github.com/goccy/go-zetasqlite/pull/88

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.4...v0.13.5

What's Changed

• View statement support by @marcellustavares in https://github.com/goccy/go-zetasqlite/pull/85

New Contributors

• @marcellustavares made their first contribution in https://github.com/goccy/go-zetasqlite/pull/85

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.3...v0.13.4

What's Changed

• Consider unspecified struct fields by @goccy in https://github.com/goccy/go-zetasqlite/pull/83

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.2...v0.13.3

What's Changed

• Fix named value by @goccy in https://github.com/goccy/go-zetasqlite/pull/82

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.1...v0.13.2

What's Changed

• Joins supports nested with statements by @dav009 in https://github.com/goccy/go-zetasqlite/pull/78
• Like: Wildcard error fix by @dav009 in https://github.com/goccy/go-zetasqlite/pull/79
• Remove unnecessary codes by @goccy in https://github.com/goccy/go-zetasqlite/pull/80
• Fix named argument by @goccy in https://github.com/goccy/go-zetasqlite/pull/81

New Contributors

• @dav009 made their first contribution in https://github.com/goccy/go-zetasqlite/pull/78

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.13.0...v0.13.1

What's Changed

• Support hyperloglog++ functions by @goccy in https://github.com/goccy/go-zetasqlite/pull/71
• support BIT_COUNT function by @goccy in https://github.com/goccy/go-zetasqlite/pull/72
• support SESSION_USER function by @goccy in https://github.com/goccy/go-zetasqlite/pull/73
• Support error func by @goccy in https://github.com/goccy/go-zetasqlite/pull/75
• Fix with clause in subquery by @goccy in https://github.com/goccy/go-zetasqlite/pull/76
• Fix struct type of JavaScript UDF by @goccy in https://github.com/goccy/go-zetasqlite/pull/77
• Set SQLITE_LIMIT_VARIABLE_NUMBER by @yuki0920 in https://github.com/goccy/go-zetasqlite/pull/74

New Contributors

• @yuki0920 made their first contribution in https://github.com/goccy/go-zetasqlite/pull/74

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.12.1...v0.13.0

What's Changed

• Fix orderby columns for window function by @goccy in https://github.com/goccy/go-zetasqlite/pull/70

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.12.0...v0.12.1

What's Changed

• Support auto index mode and explain mode by @goccy in https://github.com/goccy/go-zetasqlite/pull/68
• Support all aggregate functions by @goccy in https://github.com/goccy/go-zetasqlite/pull/69

Full Changelog: https://github.com/goccy/go-zetasqlite/compare/v0.11.6...v0.12.0