Tobias Brandt

> `select [*] except:[foo, bar]` Not bad, +0.5 > `select (* -[foo, bar])` Not such a fan of this. --- Another idea to throw into the mix: ```elm select [^...

> `select [^ foo, bar]` > > One downside with this is ^ seems to apply to the first item, but actually applies to all the items. I agree with...

Adding links to our recent discussion on Discord and the DuckDB developments. Discord discussion: https://discord.com/channels/936728116712316989/945832228011798528/1077845402793017384 DuckDB pivot: https://github.com/duckdb/duckdb/pull/6387

[substrait.io](substrait.io) recently added a page showcasing projects that support Substrait. Not too much there yet but useful for keeping an eye on things. [Powered by Substrait](https://substrait.io/community/powered_by/)

TIL of mood-affiliation. Yes, I don't think there's much point in supporting it until that list gets larger. The arguments for supporting it would be (if it was universally or...

Blog post by Ibis on how to use Substrait and why they support it. https://ibis-project.org/blog/ibis_substrait_to_duckdb/#why-wouldnt-i-just-use-sql-for-this

Is there a universal mapping between TINYINT, SMALLINT, and BIGINT and the corresponding number of bytes? From what I recall the meaning can be database specific.

I agree with @bpartridge . I have a design proposal for LATERAL JOINs which, similar to what we did with `loop` for RECURSIVE CTEs, in my opinion could really make...

> ```elm > from [{a = null, b = null}] > select a == b > ``` > ... evaluates to [{null}] in playground at the moment, but it should...

Just to add an example (because I lost it when my browser restarted today): ```elm let to_int = func x -> case [x=='null' => null, true => (x | as...