Therapon Skoteiniotis

Add support for set operators `UNION`, `INTERSECT` `EXCEPT`

3

## Overview Add support for set operators `UNION`, `INTERSECT` `EXCEPT` ## Tasks - [x] https://github.com/partiql/partiql-docs/pull/7 - [x] Define OUTER variants in the lexer/parser/ast - [x] Implement the simpler OUTER variants...

Ordinal Access should not be allowed in tuples

2

According to the spec: > 13.3 Attribute Ordinals in lieu of Attribute Names In certain SQL operations, an expression may refer to an attribute via its ordinal position, as dened...

Auto-coersing subqueries results when used with operators

2

Query ```sql SELECT e.name AS employeeName FROM hr.employeesNest AS e WHERE ( SELECT COUNT(*) FROM e.projects AS p WHERE p.name LIKE '%security%') > 1 ``` Data ``` { 'hr': {...

Add millisecond option for date_diff

2

It would be nice to have the option to use date_diff that outputs the time difference in milliseconds. Ex: `DATE_DIFF(milliseconds, my_timestamp_field, UTCNOW())`

Currently the Typescript code is used to generate - es6 code (this is what we currently run our tests against) - commonjs modules that create the npm package - minified...

The current tutorial for using Ion inside the browser as a `script` (not as an npm package) is primitive. The tutorial should walk through the basics of Ion and the...

The API supported bu Ion-js mimics (it is inspired by) the other programming language libs for Ion. it is a little verbose to use. Devs tends to create their Ion...

Migrate to JUnit 5

2

Not high priority but JUnit 5 has some quality of life improvements over JUnit4, for example: 1. Parametrized tests support by default, you can even rerun a single parameter on...

Add support for `RIGHT` and `FULL` outer joins

1

Add full support for `RIGHT OUTER JOIN` and `FULL OUTER JOIN`.

Depends on partiql-spec [#43](https://github.com/partiql/partiql-lang/issues/24). Add full support for SQL-92 `UNION JOIN`.