2025-11-21

What's Changed

• ORDER BY clause for multiple UNIONs to fix #7 after 11 years and 11 days
• Let SELECT * INTO SQL() handle NULL values to fix #42 after 10 years, 10 months and 7 days
• ORDER BY with numeric column ref on SELECT * to fix #125 after 10 years, 7 months and 4 days
• Use DISTINCT with object values in SELECT and SEARCH to fix #167 after 10 years, 6 months and 12 days
• Support BETWEEN operator in CASE statement to fix #735 after 9 years, 3 months, and 4 days
• Allow nested subqueries for IN clause to fix #847 after 8 years, 7 months and 29 days
• Support import of multi-sheet XLSX to fix #848 after 8 years, 7 months and 29 days
• Let SERIAL columns handle explicitly provided values including NULL to fix #895 after 8 years, 4 months and 28 days
• Let UNIQUE constraint support JSON properties and expressions to fix #925 after 8 years, 3 months, and 18 days
• Update indexes when bulk loading data to fix #1027 after 7 years, 4 months and 17 days
• Support ROW_NUMBER() OVER (PARTITION BY) syntax for row numbering to fix #1126 after 6 years, 3 months and 5 days
• Let INSERT INTO SELECT FROM overwrite data with defaults to fix #1484 after 6 years, 3 months and 5 days
• Avoid timezone challenge for test408 to accomodate #1587 after 2 years and 11 months.
• Extract compiled JS from SQL to fix #2169 7 days
• Let CREATE INDEX support qualified table names to fix #2184 after 2 days
• Qualified table names for SHOW COLUMNS and SHOW INDEX to fix #2200 after 16 hours

New Contributors

• Thank you to Github for sponsoring @Copilot who made their first contributions and helped nail issues with a combined age of 109 years, 1 month and 28 days from guiding it for a few hours. #theFutureIsNow

Full Changelog: v4.9.0...v4.10.1

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