A modern programming language that makes developers happier.

kotlinlang

```    return transaction {
      PostDAO.wrapRows(
        Posts
          .innerJoin(PostsTags, {Posts.id}, {<http://PostsTags.post|PostsTags.post>})
          .innerJoin(Tags, {Tags.id}, {PostsTags.tag})
          .selectAll()
          .andWhere {
            Posts.title like "%$query%" or (Tags.name inList tags)
          }
          .withDistinct()
      ).map {
        it.toModel()
      }
      .distinct()
      .toList()
    }```

It's better to use `select {} ` instead of `selectAll().andWhere{}`. `select` is the alias to sql `where`.