hello scalikejdbcの一部切り抜き

sample.scala

  def findNoSkillProgrammers()(implicit session: DBSession = autoSession): List[Programmer] = withSQL {
    select
      .from(Programmer as p)
      .leftJoin(Company as c).on(p.companyId, c.id)
      .where.notIn(p.id, select(sqls.distinct(ps.programmerId)).from(ProgrammerSkill as ps))
      .and.append(isNotDeleted)
      .orderBy(p.id)
  }.map(Programmer(p, c)).list.apply()