This method inserts the rows and returns columns you want from the inserted rows.
This is not supported by all databases, unfortunately.
def insertCustomers: List[Customer] = ctx.run {
sql"""
INSERT INTO customers(name)
VALUES ('abc'), ('def'), ('ghi')
RETURNING id, name
""".insertReturningRows[Customer]()
}
Here in one query you can both insert + get the row you inserted.