tminglei/slick-pg

I am new to slick and i am trying to convert a sql query to slick and need help for the same.

My table is:

    final case class TableExp(
                                id: String,
                                key: String,
                                value: String
                              )
    final class TableExp(tag: Tag)(implicit val schema: String)
      extends Table[TableExp](tag, Some(schema), "table") {
      def id = column[String]("id")

      def key = column[String]("key")

      def value = column[String]("value")

      def * =
        (id,
          key,
          value
          ).shaped <> (TableExp.tupled, TableExp.unapply)

      def getData(id: String) =
      {

        TableQuery[TableExp].filter(res => res.id === id || res.id === "id1").map(_.key).distinct
      }
    }

And the sql query is:

select distinct key, first_value(value) over (partition by key order by case when t.id=$id then 0 else 1 end) value from table t where t.id in ($id, 'id1')) t

So far i have tried this:

     def getData(id: String) =
      {

            TableQuery[TableExp].filter(res => res.id === id || res.id === "id1").groupBy(_.key).map
           {
            case (a,b) => Over.partitionBy(b.map(_.key))
             }
      }