MSSQL Boolean type

[bminer]

Unfortunately for Microsoft, their RDBMS does not understand TRUE and FALSE. It only understands 1 and 0.

useFlavour('mssql') should be adjusted to accommodate this inferior database. ;)

Workaround:

const squel = require('squel').useFlavour('mssql');

// Handle booleans better
squel.registerValueHandler('boolean', (val) => val ? '1' : '0');

squel
  .insert()
  // .......