Is there a way to use fully qualified table names ...

# exposed

[Endre Deak]

Is there a way to use fully qualified table names in Exposed DSL? I’m dealing with multi-tenant database structure, and right now I do something like

transaction {
    SchemaUtils.setSchema(tenantSchema)
    val result = // do my db thing
    SchemaUtils.setSchema(defaultSchema)
    return result
}

I’ve tried to have specific Database instance for each schema, but that makes connection pooling a lot more complex rather than having a single HikariCP connection pool.