Joining dynamic SQL strings

[Pomanks]

Hi,

I'm trying to achieve something like the following, in order to filter a query dynamically:

.where { 
  [an array of values]
    .map { #sql(…) }
    .joined(operator: .or)
}

The problem is I'm either not using the correct type to infer a joined(…) method or there simply isn't?

I tried using reduce(into:_:) to use or(_:) but I then have a type mismatch (I assumed the resulting query would be some QueryExpression<Bool>).

Any help/guidance would be much appreciated! 🤗

[stephencelis]

You can drop down to the query fragment level:

.where {
  #sql(
    [an array of values]
      .map(\.queryFragment)
      .joined(separator: " OR ")
  )
}

[Pomanks]

Just what I needed, thanks a lot! 😄