- 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
this
andthat
as 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_parquet
andread_csv
from (read_parquet 'artists.parquet')
join (read_csv 'albums.csv') [==track_id]
- Updated to PRQL 0.7.0
- Add
?
,:name
variable 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:
prqlc
command line tool is not required anymore
- Introduce prql-java library to call PRQL API instead of using
prqlc
command line, and no need to installprqlc
anymore. - 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
.
let
support 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
duckdb
added in dialects
from_text
support
- 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
prqlc
instead ofprql-compiler
command line tool: please install it bycargo install --bins --features=cli prql-compiler
- Plugin version now follows PRQL version
- Some bugs fixed
- PRQL Injection for
@PRQL
annotation in Java - Icon support for completion items
- SQL transpile by
prql-comiler
command line - Table name completion if datasource setup in IDE
sort -age
marked as error now
- Syntax support
- SQL injection
- Code completion