std.in operator does not support expression on left-hand-side about prql HOT 2 CLOSED

Good example and it's encouraging to see you pushing functions like this!

There are definitely a few things up — it obv shouldn't panic there.

Also putting an s-string within the pipeline panics :(

let coalesce_bool = func
  val <scalar || null>
  -> case [
    (s"{val}" | in ["no", "n", "N", "false"]) => false,
  ]

from [{foo = 1}, {foo = null}]
derive { foo_b = coalesce_bool foo }

For completeness — if I put this in the playground, duckdb doesn't raise an error — does it on your end? Is the error message because of the type of some data that's not there?

let coalesce_bool = func
  val <scalar || null>
  -> case [
    val == null => null,
    val == 0 => false,
    val == 1 => true,
    (val | in ["no", "n", "N", "false"]) => false,
    (val | in ["yes", "y", "Y", "true"]) => true,
  ]

from [{foo = 1}, {foo = null}]
derive { foo_b = coalesce_bool foo }

For a workaround — does an s-string in another transform suffice for the moment?

from [{ a = 1 }]
derive a_ = (s"{a} as VARCHAR")
derive { b = ( a_ | in [2, 3] ) }

from prql.

I have to run now, but quickly -- I can provide some more details later on how I've managed to trigger the underlying situation, but unfortunately an s-string in another transform isn't a great solution because of the way this function is used in other parts of our PRQL.

I'm hoping that the PR that I threw together is a simple solution; it does fix the s-string panic as well.

from prql.