PRQL compiler CLI - prqlc 0.10.0 ڈاؤن لوڈ

- _Breaking:_ Case syntax now uses brackets [] rather than braces {}.
To convert previous PRQL queries to this new syntax simply change case { ... } to case [ ... ]. (@AaronMoat, #3517)
- _Breaking_: The std.sql.read_csv function is now compiled to read_csv by default.
Please set the target sql.duckdb to use the DuckDB's read_csv_auto function as previously. (@eitsupi, #3599)
- The std.sql.read_csv function and the std.sql.read_parquet function supports the sql.clickhouse target. (@eitsupi, #1533)
- Add std.prql_version function to return PRQL version (@hulxv, #3533)
- Add support for hex escape sequences in strings.
Example "Hello \x51". (@vanillajonathan, #3568)
- Add support for long Unicode escape sequences.
Example "Hello \u{01F422}". (@vanillajonathan, #3569)
- Add support for binary numerical notation.
Example filter status == 0b1111000011110000. (@vanillajonathan, #3661)
- Add support for hexadecimal numerical notation.
Example filter status == 0xff. (@vanillajonathan, #3654)
- Add support for octal numerical notation.
Example filter status == 0o777. (@vanillajonathan, #3672)
- New compile target sql.glaredb for GlareDB and integration tests for it (However, there is a bug in the test and it is currently not running). (@universalmind303, @scsmithr, @eitsupi, #3669)
- Allow cmd-/ (Mac) or ctrl-/ (Windows) to toggle comments in the playground editor (@AaronMoat, #3522)
- Limit maximum height of the playground editor's error panel to avoid taking over whole screen (@AaronMoat, #3524)
- The playground now uses Vite (@vanillajonathan).
- Add a CLI command prqlc collect to collect a project's modules into a single file (@aljazerzen, #3739)
- Add a CLI command prqlc debug expand-pl to parse & and expand into PL without resolving (@aljazerzen, #3739)
- Bump prqlc's MSRV to 1.70.0 (@eitsupi, #3521)
- Pygments, a syntax highlighting library now has syntax highlighting for PRQL. (@vanillajonathan, #3564)
- chroma, a syntax highlighting library written in Go and used by the static website generator Hugo. (@vanillajonathan, #3597)
- scc, a source lines of code counter now has support for .prql files. (@vanillajonathan)
- gcloc a source lines of code counter now has support for .prql files. (@vanillajonathan)
- cloc a source lines of code counter now has support for .prql files. (@AlDanial)
- gocloc a source lines of code counter now has support for .prql files. (@vanillajonathan)
- The Quarto VS Code extension supports editing PRQL code blocks (prqlr is required to render Quarto Markdown with PRQL code blocks). (@jjallaire)
- @hulxv, with #3533
- @AaronMoat, with #3522
- @jangorecki, with #3634