SQLite Comaptibility about squel HOT 3 CLOSED

Squel purports to support standard SQL queries that everyone uses, though I don't claim Squel's support to be comprehensive by any means. People can add support for whatever querying they desire - if it falls outside the standard then it can be added to a 'flavour' of Squel, similar to how Squel already has PostgreSQL and MySQL flavours. I used a SQLite a while back and I remember there were a few things (like PRAGMA queries) that are specific to it so perhaps it would be better to introduce an sqlite flavour. I'm happy for this to happen as and when people need it but I don't deem it necessary to investigate it fully right now.

from squel.

i just hit a sqlite issue - insert().setFields({boolfield: true}) => INSERT ... (boolfield) values (TRUE).

sqlite says no such column: TRUE. it'd be nice if squel would translate true/false to 1/0 when the flavor is set to sqlite.

from squel.

as soon as I posted this, I found squel is already good at doing custom data type handling. thanks!

squel.registerValueHandler('boolean', sqlite_bool)

function sqlite_bool(tf) {
  return tf ? "1" : "0"
}

from squel.