How To Interpolate Queries?

You can interpolate queries in other queries, just like values:

val whereQuery = sql"WHERE .."
sql"""
  SELECT customer_id, name
  FROM customers
  ${whereQuery}
""".readRow[Customer]()