scala - Compose "Insert...Select...Where" query -

i'm trying compose query using slick 3.0, can't seem figure out.

the equivalent sql "insert savedmail select * inbox inbox.id = 1"

val mailtable = tablequery[tables.inbox] val savedmailtable = tablequery[tables.savedmail] val select = mailtable.filter(_.id === msgid) 

i'm stuck on how insert now. appreciated.

here's solution i've come with. perhaps there's way not use forceinsertquery, hey, works.

val mailtable = tablequery[tables.inbox] val savedmailtable = tablequery[tables.savedmail]  val select = mailtable.filter(_.id === msgid).map(c => (c.id, c.touserid, c.fromuserid, c.mailtype, c.subject, c.msg, c.postdate)) val q = savedmailtable.map(c => (c.id, c.touserid, c.fromuserid, c.mailtype, c.subject, c.msg, c.postdate)) forceinsertquery select