$sth->prepare(
        table{users}->select(
          all,
          where(
            like{name}->quote('%john%')
          )
        )
      )