如何使用Slick创建动态查询？

import slick.jdbc.MySQLProfile.api._
import scala.concurrent.ExecutionContext.Implicits.global

val db = Database.forConfig("your-db-config")

case class User(id: Int, name: String, age: Int)

class Users(tag: Tag) extends Table[User](tag, "users") {
  def id = column[Int]("id", O.PrimaryKey)
  def name = column[String]("name")
  def age = column[Int]("age")
  
  def * = (id, name, age) <> (User.tupled, User.unapply)
}

val users = TableQuery[Users]

def dynamicQuery(name: Option[String], age: Option[Int]) = {
  val baseQuery = users.filter { user =>
    List(
      name.map(user.name === _),
      age.map(user.age === _)
    ).collect({ case Some(criteria) => criteria }).reduceLeftOption(_ && _)
  }
  
  db.run(baseQuery.result)
}

val result = dynamicQuery(Some("John"), Some(25))
result.onComplete {
  case Success(users) => users.foreach(println)
  case Failure(ex) => println(s"An error occurred: ${ex.getMessage}")
}