Do I need to create a mapper fun to transform ResultRow to the class I want? Something like: Articles.select { Articles.id eq I’d }.map { toArticle(it) }.single()

yes, you do if you don’t use the DAO method