2025-11-12

What's Changed

• Regression of piping data via txt() in CLI mode to fix #2149

New Contributors

• Thank you to @ammeek for their first contribution in #2159

Full Changelog: v4.8.0...v4.9.0

2025-11-04

What's Changed

• Support MAX on dates to fix #2147
• Let ROUND of NULL be undefined to fix #2155

Also

• Thank you to @t-wy for lots of well documented questions and challenges.

Full Changelog: v4.7.0...v4.8.0

2025-11-03

What's Changed

• Deal with Non-ASCII characters in JSON() import to fix #2112 by @brettz9

Also

• Thanks to @garyg1 making their first contribution and helping the quality of the readme info.

Full Changelog: v4.6.6...v4.7.0

2025-04-02

What's Changed

• Fix JOIN on JSONL sources by @t83714 in #2082
• Allow SELECT * for pivot to fix #490
• Update dependency axios to v1.8.2 for security reasons

Full Changelog: v4.6.4...v4.6.6

2025-02-28

What's Changed

• Edit types to fix #2053

Full Changelog: v4.6.3...v4.6.4

2025-02-11

What's Changed

• Better error handling by @t83714 in #2051

Full Changelog: v4.6.2...v4.6.3

New Contributors

• Thank you to @t83714 for making their first contribution

2025-01-11

What's Changed

• Avoid caching dirty data to fix #2027 - by @paulrutter

Full Changelog: v4.6.1...v4.6.2

v4.6.0

What's Changed

• Support for BigInt data type for aggregate functions by @KamilStefanco in #1981

New Contributors

• Thank you to @KamilStefanco who made their first contribution 👑

Full Changelog: v4.5.2...v4.6.0

2023-08-01

What's Changed

• fix: Let EXISTS work for subqueries - thanks to @alsundukov in #1952 for solving the real problem of #1904

Full Changelog: v4.5.0...v4.5.1

2024-07-11

What's Changed

• Fix EXISTS Function for Subqueries (Issue #1904) by @Midwayne in #1939
• fix insertion of empty objects with union all statements by @kmr-rohit in #1940

New Contributors

• @Midwayne made their first contribution in #1939
• @kmr-rohit made their first contribution in #1940

Full Changelog: v4.4.0...v4.5.0