Hi,
I created a simple project to reproduce the error. Just run test to see the problem
doobiesqlite.tar.gz

I have a simple table with just a column of type BIGINT and a case class with a Long field
When I check the SELECT it works fine, but the INSERT fails with

  INSERT INTO test VALUES (?)
  ✓ SQL Compiles and TypeChecks
  ✕ P01 Long  →  VARCHAR (VARCHAR)
    Long is not coercible to VARCHAR (VARCHAR) according to the JDBC
    specification. Expected schema type was BIGINT.

It seems that the BIGINT turn out to be a VARCHAR for some reason.

PS Sqllite doesn't have BIGINT, but it's automatically mapped to INTEGER