Kysely is great and I was happy to use it in my last work project.
In theory, implementing "real world app" with Kysely might have some quirks (or maybe not), but implementing this app one more time is time-consuming so not gonna do that.
Though it would be interesting to see if it's much easier to use than Knex, as they are similar, but take different approaches for query builder design.