Is it possible to store the raw Sql statements Exposed passes to the DB in a variable? I'm aware logging the statements via

addLogger(StdOutSqlLogger)

but how can I access/interact with this info? ex:

Exposed: transaction { table.select { table.id eq 123 } }
Raw SQL ran against DB: SELECT * FROM TABLE WHERE ID = 123;

//desired result
val executedSql = SELECT * FROM TABLE WHERE ID = 123;
println(executedSql)

How can I access the raw sql executed against the DB?

Hi Eric, You can do something like this:

transaction { 
    val rawSQL = table.select { table.id eq 123 }.prepareSQL(this) 

    println(rawSQL)
}

Thank you very much, that worked! Is it possible to do the same thing from an entity? ex:

object TestTable : UUIDTable(columnName = "id", name = "test_table") {
    val data = uuid("data")
}

class TestRecord(id: EntityID<UUID>) : UUIDEntity(id) {
    var data by TestTable.data
}

val rawSQL = transaction {
    TestRecord.findById(<id>).prepareSQL(this)
}

println("rawSQL: $rawSQL")

Not when you use

findById

, since it already returns you an Entity back, not a query