I have a very complex set of relationships of a bunch of tables, and from table A, I want to be able to access A.B.C.D.name... it'd be a pity to have to create an entity for each one, load them all and traverse them all just to access that field's value...

Is there one-to-one relation between tables? Do you need only read access?

They're all linked through foreign keys, and I need read, and preferrably write only if all the entities between exist... I wouldn't need that field to be initialized in

new { }

though.

DAO supports updates only on the Entity table, but for read you can override

dependsOnTable

and

dependsOnColumns

in EnityClass:

override val dependsOnTables = ItemTable innerJoin CategoriesTable
override val dependsOnColumns = ItemTable.columns + CategoriesTable.name

Then just delegate to CategoriesTable.name:

val categoryName: String by CategoriesTable.name

That's already not bad! Just wondering why we need to let it know the dependencies if we already declare them in the Table, can't they be inferred? -- but this is probably liveable, until a ksp plugin to generate all the biolerplate code could be made...