dnwpark

Also moved the enum from `edb/pgsql/compiler/pathctx.py` to `edb/pgsql/common.py`.

Add array modifying functions

8

Added `array_set`, `array_insert`, and `array_remove`. The query `SELECT array_set([1, 2, 3, 4], 2, 9);` returns `[1, 2, 9, 4]`. The query `SELECT array_insert([1, 2, 3, 4], 2, 9);` returns `[1,...

Allow directly nested arrays of arrays

1

Allows directly nested arrays. The query `select ([[1],[2]]++[[3]])[1:3][0];` returns `[2]`. The query `select find(array_replace([[1],[2],[3]],[2],[4]),[1]);` returns `0`.

ISE when selecting link property in a complicated expression

2

Given the schema: ``` type Person { required name: str; } type Queue { multi people: Person { position: array; } } ``` The following query produces an assertion failure...

Given a schema: ``` type Foo { constraint exclusive on ('C'); constraint exclusive on ('A'); constraint exclusive on ('D); constraint exclusive on ('B'); }; ``` The query `describe schema as...

Add SDL to migrations.

1

When doing migrations or migration rewrites, the stored `schema::Migration` objects will have their resulting SDL saved. related #7621 Note: I made the `sdl` property required, however the issue mentions an...

Type checks in if/else should affect the types in the results

1

Given the schema: ``` type A {a: int64}; type B {b: int64}; ``` Consider the query: ``` with x := (select {A, B}) select if x is A then x[is...

In addition to `?=` and `?!=`, it would be useful to have other coalescing comparisons: `?>` `?>=` `?