prql-compiler 0.7.1

PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement.
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55

# PRQL test-databases

Test PRQL queries against various SQL RDBMS.

## Data

Columns are renamed to snake_case, so Postgres and DuckDb don't struggle with
them.

For optimal accessibility, portability between databases and file size, all
tables are stored as CSV files. Their current size is 432kB, it could be gzip-ed
to 112kB, but that would require a preprocessing step before running
`cargo test`.

## RDMBS

### SQLite

Can be run as part of `cargo test`. Uses bundled sqlite, compiled as part of
cargo build.

### DuckDb

Can be run as part of `cargo test`. Uses bundled DuckDb, compiled as part of
cargo build.

### Postgres, MySQL, SQL Server

These will not run as a part of `cargo test`. Use
`cargo test --features=test-external-dbs` instead. Make sure to start docker
compose before (see below).

## Docker compose

To test the external databases, docker needs to be installed.

Steps to run the tests:

1. Run docker compose (may take a while on the first time):

   ```
   $ cd prql-compiler/tests/integration
   $ docker compose up
   ```

2. Run the tests:

   ```
   $ cargo test --features=test-external-dbs
   ```

## Test organization

We follow the advice in
<https://matklad.github.io/2021/02/27/delete-cargo-integration-tests.html>.