- Fix
this,thatas param:count this - Fix
group { a, b } - Use SQL icon to convert PRQL to SQL
- Update to prql 0.13.7
- Add SQL array support:
filter (department | in ["IT", "HR"]) - Update to prql 0.13.5
- Compatible with JetBrains IDEs 2025.3
- Update to prql 0.13.4
- Compatible with JetBrains IDEs 2025.1
- Update to prql 0.13.0
- Update to prql 0.12.2
- Type support:
type array_of_int = [int] - Lutra support:
@(lutra.sqlite {file="chinook.db"})
- Fix some lexer and parser issues
- Update to prql 0.11.3
- Optimize for let statement
- Support for Lutra statement
- Update to prql 0.10.0
- Support for hex/Unicode escape sequences in strings
- Support for binary/octal/hexadecimal numerical
- Update to prql 0.9.5
- New tuple support:
select {first_name, last_name} - New function definition support:
let add = a b -> a + b thisandthatas tale alias support- Relation literals create a relation (a "table") as an array of tuples:
from [{a=5, b=false}, {a=6, b=true}]
- Add
~=regex search operator
- Infix
&&,||operator support - New functions
read_parquetandread_csv
from (read_parquet 'artists.parquet')
join (read_csv 'albums.csv') [==track_id]
- Updated to PRQL 0.7.0
- Add
?,:namevariable support for Java JDBC only
- Inspection: sync transpiled SQL from PRQL to
@Query - Updated to PRQL 0.6.1
- case instead of switch
- loop support
- some bugs fixed
- prql-lib bundled:
prqlccommand line tool is not required anymore
- Introduce prql-java library to call PRQL API instead of using
prqlccommand line, and no need to installprqlcanymore. - Code format support
- Brace matcher support
- Execution icon: execute PRQL by JDBC Console. Please set up local datasource and open an active JDBC Console first.
- Target dialect support from
Settings->Languages & Frameworks->SQL dialects
- table name completion with multi schemas, for example
Postgres.
letsupport for table definition- Syntax high light for S-Strings and F-Strings
- Column high light for S-Strings and F-Strings
- Add S-Strings for Join
duckdbadded in dialects
from_textsupport
- Remove DumbAware to avoid index not ready exception
- switch enhancement
- append support
- Excluding columns:
select ![title, composer] - Numbers can now contain underscores:
select [ small = 1.000_000_1, big = 5_000_000] - Use
prqlcinstead ofprql-compilercommand line tool: please install it bycargo install --bins --features=cli prql-compiler
- Plugin version now follows PRQL version
- Some bugs fixed
- PRQL Injection for
@PRQLannotation in Java - Icon support for completion items
- SQL transpile by
prql-comilercommand line - Table name completion if datasource setup in IDE
sort -agemarked as error now
- Syntax support
- SQL injection
- Code completion