Elvis Pranskevichus

@msullivan, this is a common gotcha, let's see if we can prioritize a fix.

`json_object_agg` for consistency with `array_agg`, and have a `set of` input.

Hmm. Not really. We have `array_agg` and `array_unpack`

I'd still prefer `json_object_pack` to be an aggregate (as opposed to array-taking).

Yeah, I think our advice for "fixes that break old migrations" would be to do a manual migration squash. New regressions shouldn't require anything special other than waiting for a...

`@target` is a property present on all links. `Foo.link@target` is equivalent to `Foo.link` in an expression, and it's probably easiest to make it equivalent in `compile_path` to avoid having to...

> Hm, though actually maybe not deduplicating makes more sense, since it is operating on the _link_... Exactly. See comment in `attach_path` in `scopetree.py`

There used to be `INTERSECT` and `EXCEPT` infix operators, which I would prefer (because we have infix `UNION`). Also see discussion in #5 where these have been removed. I think...

Good point.

SQL supports commutative multiset semantics on `intersect` and `except` (via the `all`) modifier, so there's no problem here. Also, per discussion with @vpetrovykh, we should look into the possibility of...