0.13.11

0.13.11 has 75 commits from 7 contributors. Selected changes:

Features:

• Add support for date.to_text for BigQuery (@segv, #5712)

Fixes:

• Prevent panic on bare * in select (@max-sixty, #5696)
• Handle partial application of transforms in user-defined functions (@max-sixty, #5663; reported by @Rafferty97)
• Keep Computes with Aggregate when Filter follows (@max-sixty, #5639; reported by @matiastoro)
• Preserve sort before take in CTE (@max-sixty, #5638; reported by @lukapeschke)
• Preserve sort with empty group {} (@max-sixty, #5635)
• Return proper error for bare lambda expressions (@max-sixty, #5634)
• Prevent DISTINCT ON internal sorting from leaking past joins (@max-sixty, #5633; reported by @annashmatko)
• Fix invalid MSSQL SQL when DISTINCT and FETCH are combined (@max-sixty, #5630)

Documentation:

• Editorial tweaks (@richb-hanover, #5645)

Integrations:

• micro 2.0.15 has syntax highlighting for PRQL. (@vanillajonathan)

Internal changes:

• Use chumsky 0.12.0 for all targets (#5659)
• Update rust toolchain version (#5673)
• Fix mdbook admonition syntax for mdBook 0.5 native support (#5649)

New Contributors:

• @segv, with #5712

0.13.10

0.13.10 completes the npm OIDC publishing fix from 0.13.9.

Features:

• Add read_json support for DuckDB and ClickHouse (@adamnemecek, #5608)

Fixes:

• Fix text.length on Snowflake (@priithaamer, #5614)

Internal changes:

• Fix npm OIDC publishing by upgrading to Node 24 (@max-sixty, #5619)
• Fix push-web-branch workflow permissions (@max-sixty, #5620)

0.13.9

0.13.9 is a re-release of 0.13.8 with fixed npm publishing.

Internal changes:

• Use OIDC for npm publishing (@max-sixty, #5609)

0.13.8

0.13.8 has 47 commits from 6 contributors. Selected changes:

Features:

• Add named parameter support for DuckDB read_parquet (@max-sixty, #5563)

Fixes:

• Snowflake interval quoting style (@priithaamer, #5604)
• Return error instead of panicking when window rows/range is not a range (@max-sixty, #5603)
• Add ORDER BY fallback for Snowflake window functions (@max-sixty, #5583)
• DISTINCT ON to include wildcard when projection is empty (@max-sixty, #5562)
• Lineage traces through CTEs to source tables (@nightscape, #5581)
• Lineage works with unions (@nightscape, #5550)
• Handle lineage correctly when group pipeline simplifies to non-TransformCall (@max-sixty, #5584)
• Return error for join referencing inaccessible table (@max-sixty, #5587)
• Error when table variable used in scalar context (@max-sixty, #5585)
• Improve error messages for missing main pipeline (@max-sixty, #5565)
• Provide clear error for empty tuple/array in from (@max-sixty, #5564)
• Improve error message for negative numbers in transforms (@max-sixty, #5566)

Documentation:

• Close HTML comment in sort.md documentation (@max-sixty, #5597)

Integrations:

• Add grammar file for Raku (@vanillajonathan, #5576)

Internal changes:

• Upgrade mdbook to 0.5.0 (#5568)
• Update macOS runners to version 15 (#5596)
• Remove 2nd person from error messages (#5567)

New Contributors:

• @nightscape made their first contribution in #5550

0.13.7

0.13.7 has 8 commits from 6 contributors. Selected changes:

Fixes:

• Fix INTERVAL quoting in Redshift (@lukapeschke, #5545)
• Fix support for text.contains in sql.redshift target (@dimtion, #5549)
• Fix division in Redshift produces float (@priithaamer, #5546)
• Use || operator over CONCAT for std.concat in Redshift (@lukapeschke, #5540)

Web:

• Bump vite from 7.1.11 to 7.2.0 in playground (#5547)

0.13.6

0.13.6 has 40 commits from 6 contributors. Selected changes:

Features:

• Add support for Redshift dialect (@priithaamer, #5537)

Fixes:

• Fix append regression in 0.13.5 (@priithaamer, #5495)
• Fix s-string escaping (@priithaamer, #5497)
• Filter out attestation manifests in platform verification (@max-sixty, #5509)

Internal changes:

• Migrate devcontainer build from QEMU to native ARM64 runners (@max-sixty, #5506)
• Migrate from markdown-link-check to lychee (@max-sixty, #5519)
• Use zero-copy slice for binary/hex/octal number parsing (perf improvement, @max-sixty, #5488)
• Update rust toolchain version (#5536)
• Do not allow incompatible rust-version dependencies (@eitsupi, #5493)
• Pin typos to v1.37.2 (@max-sixty, #5510)

0.13.5

0.13.5 has 237 commits from 14 contributors. Selected changes:

Features:

• Support for SQL arrays as s[...] syntax (@robert Valek, #5312)
• Extract SQL column names from s-string tables when possible (@lukapeschke, #5310)

Fixes:

• Sort step before an aggregate step no longer requires its columns to avoid a group by clause error (@julien-pinchelimouroux, #5347)
• Always add quotes on identifiers for Snowflake dialect (@julien-pinchelimouroux, #5461)
• Join with table containing column named "source" now works correctly (@priit Haamer, #5468)
• Columns required by sorting are properly redirected (@lukapeschke, #5464)
• Ensure sorts are done on columns of the right table (@lukapeschke, #5338)
• Deduplicate selected items in gen_projection (@lukapeschke, #5305)
• Handle complex append cases (@Elouan Poupard-Cosquer, #5366)
• Improve requirement logic (@Elouan Poupard-Cosquer, #5357)
• Avoid type mismatch with Postgres in append (@Elouan Poupard-Cosquer, #5343)
• Apply column order on CTEs in append (@Elouan Poupard-Cosquer, #5323)

Documentation:

• Fix binary literal example (@ftsfranklin, #5475)
• Use correct table in grouping tutorial (@fnuttens, #5332)

Integrations:

• TEA 63.3.1, a Qt-based text editor has syntax highlighting for PRQL (@vanillajonathan, #5220)
• Micro text editor grammar is now upstream (@vanillajonathan, #5353)
• Add LSP stub (@vanillajonathan, #5197)

Internal changes:

• Upgrade parser and lexer to chumsky 0.11, providing a 7x performance improvement (#5223, #5476, #5477)
• Set Rust linker on win64, fix build crash (@kgutwin, #5345)
• Integration tests compile all dialects and diff (@kgutwin, #5344)

New Contributors:

• @Elouan Poupard-Cosquer, with #5366
• @priit Haamer, with #5468
• @robert Valek, with #5312
• @fnuttens, with #5332
• @ftsfranklin, with #5475
• @julien-pinchelimouroux, with #5347

0.13.4

0.13.4 is a small bugfix release.

It has 57 commits from 10 contributors. Thanks to @lovasoa & @nsiregar for their first contributions to PRQL

0.13.3

0.13.3 is a small release containing a few bug fixes and improvements. It has 86 commits from 10 contributors. Selected changes:

Fixes:

• Sort steps in sub-pipelines no longer cause a column lookup error (@lukapeschke, #5066)
• Dereferencing of sort columns when rendering SQL now done in context of main pipeline (@kgutwin, #5098)

New Contributors:

• @lukapeschke, with #5066

0.13.2

0.13.2 is a tiny release to fix an issue publishing 0.13.1 to Crates.io