Nick Crews

This does actually seem to work in shell.duckdb.org to add scalar to scalar: ```sql SELECT (SELECT count(*) FROM 'https://shell.duckdb.org/data/tpch/0_01/parquet/lineitem.parquet') + (SELECT count(*) FROM 'https://shell.duckdb.org/data/tpch/0_01/parquet/customer.parquet'); ``` or to add a scalar...

@cpcloud isn't .count() always a scalar? I definitely assumed it was, I think (no evidence) that others will think the same thing, especially if coming from pandas/python world, where semantically...

Not at a computer right now to test, but one example of a scalar from one table needing to interact with another table is a "manual autoincrement": `ibis.union(t_new.mutate(id=ibis.row_number() + t_old.id.max()),...

In SQL, is my assumption correct that you can combine two scalar expressions in arbitrary ways?

sounds good, let's start with array for now.

I agree the name "literal" isn't great, I'm not wedded to stuffing that functionality in there, but is there some other good way of solving my problem? I just updated...

> what do you think about a backend.explain(expr) method? I think that sounds nice, even if it returns teh raw string. However, to avoid needing to do a private method...

yup, just include it in the docs so that we know it is a stable(ish) API. No functional changes needed.

I am a huge fan of this. I'm curious if we could make this compatible with https://github.com/ibis-project/ibis/issues/9324, eg for the `data` I would want to be able to pass in...

To be clear, I don't think my proposal needs to be part of this exact PR, I just want to design the semantics here so we can add that functionality...