David Lurton

The main issue is that we are not calling `.close()` on `FileInputStream`. Some ideas for implementing this on an `Iterator`: https://stackoverflow.com/questions/3257972/closing-a-java-util-iterator ? Perhaps a `ClosableSequence` is the right approach here?...

`SELECT VALUE` is a work-around, however the original query should work according to SQL-92. From the [SQL-92 specification: 8.4 ](https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt): ``` ::= ... [ NOT ] IN ::= | .......

It is absolutely possible to make this query work if: - For the right-hand side of `IN`, we coerce a bag of structs with a single field to a bag...

Oops, no. Just the other stuff. I thought I had fixed that.

To be clear, only this commit was intended to bed in this PR. I will fix tomorrow. https://github.com/partiql/partiql-spec/commit/76320926ebea683f9f0fb99bb554ecc794759a5e

Also, the template I added here is simplified and modified for our purposes from the Rust equivalent: https://www.github.com/rust-lang/rfcs/tree/master/0000-template.md Thought that might be a reasonable starting point anyway. I am not...

Reuploaded: [main.pdf](https://github.com/partiql/partiql-spec/files/5330064/main.pdf)

### `LET` after `LIMIT`: - Depending on the resolution of [#281](https://github.com/partiql/partiql-lang-kotlin/issues/281), if the `LIMIT` clause executes after the projection then it will be impossible to reference any varaibles defined by...

### `LET` in the `SELECT` projection What is a use case for a `LET` clause in the `SELECT` projection? I'm not sure it makes sense to support `LET` in there...

### `LET` in `ORDER BY` I suggest at first we don't support `LET` in this clause since there is no semantic difference between declaring new `LET` bindings here and in...