val result = for {
  // open the connection asynchronously
  connection <- dbSupport.connect()
  _ <- connection.beginTransaction()
  insertedInfo <- connection.executeUpdate(
	"INSERT INTO employees (emp_no, birth_date, first_name, last_name, gender, hire_date) " +
	"VALUES (42, '1986-05-07', 'Roman', 'Stoffel', 'M', '2012-05-17')")
  statement <- connection.prepareQuery("SELECT first_name FROM employees WHERE emp_no = ?")
  queryResult <- statement.execute(42)
  _ <- connection.rollback()
  _ <- connection.close()
} yield queryResult