A modern programming language that makes developers happier.

kotlinlang

Does Select Exists clause work for MSSQL in Exposed? Mssql does not support using EXISTS() directly in select clause, and it must be wrapped in case statement (<https://stackoverflow.com/questions/2759756/is-it-possible-to-select-exists-directly-as-a-bit|SO-post>) . However, it seems that Exposed's case().When(..) does not support the `Exists` class returned from the `exists()` function. Example use case: I have Person table and PersonReview table with fk to Person table. I want to select all people and include a bit/bool value if the individual persons have a review or not.

Hi <@U011CJ3GUPL> Using version 0.45.0 and MSSQL, this works on our end:
```// query based on the SO suggested workaround
val existsOp = exists(Person.select { Person.name like "A%" })
val caseCondition = Case()
    .When(existsOp, intLiteral(1))
    .Else(intLiteral(0))
Person.slice(caseCondition).selectAll().toList()

// generates SQL
// SELECT CASE WHEN EXISTS (SELECT * FROM Person WHERE Person."name" LIKE 'A%') THEN 1 ELSE 0 END FROM Person```

Thank you for your reply! :raised_hands:  I will check out your query when I get back to my project