Just glanced through the article; biggest difference I'd say between the two libraries would be, one composes, the other doesn't.

    val base = for {
      ur <- UserRole
       u <- ur.user
       r <- ur.role
    } yield (ur, u, r)

    val withManager = for {
      (ur, u, r) <- base
              ts <- TeamStaff if u.id === ts.userId
    } yield (ur, u, r, ts)

    val teams = for {
      (_, _, _, ts) <- withManager
                 t  <- Team if t.id === ts.teamId
    } yield (ts, t)

You can slice and dice a schema however you like, building up queries from other queries, none of which are run until you execute them. Basically you get semantically the same query plans as you'd get writing plain sql, but it's all type checked, sql injection safe, and compiled (queries generally are generated at compile time, not run time).

Quill, another Scala FRM library, is worth checking out in this regard, as is Haskell's Esqueleto.