I know how to query data using query DSL, i.e. `My...

# exposed

[Raf Szałański]

I know how to query data using query DSL, i.e. MyTable.select { <condition >}.andWhere { <another condition }.orderBy( <col, order> ) and I also know how to execute raw SQL via TransactionManager.current().exec but is it possible to mix these two worlds? I’m thinking of situations in which Exposed does not support certain SQL expressions, i.e. tuple comparison:

WHERE (id, col1, col2) > (?, ?, ?)

I used to use quite a lot of Rails/ActiveRecord and it had a really neat feature of adding predicates written in raw SQL as raw clauses (with safe parameter binding). I’m thinking of writing my own operator which can work with tuples, triples etc although it isn’t the most straightforward process. I’d appreciate any help!