s-string containing full expressions?

[max-sixty]

What's up?

Currently expressions in s-strings can only contain single columns:

from invoices
derive x = s"{foo} + 5"

SELECT
  *,
  foo + 5 AS x
FROM
  invoices

But I think it should be fine to expand this to allow arbitrary expressions:

from invoices
derive x = s"{foo - bar} + 5"  # currently fails

SELECT
  *,
  foo - bar + 5 AS x
FROM
  invoices

Any thoughts on why we shouldn't do this?

[aljazerzen]

Any thoughts on why we shouldn't do this?

Because it's hard to implement :D

Not impossible, though. And it would be genuinely useful.