Dialect selection rather than both mysql & postgres

[fritzy]

Knex does it like this:

let knex = require('knex')({dialect: 'pg'})

I could see having a .PG and .MySQL object, and sharing code where possible, or having a constructor like knex with a dialect option.

[felixfbecker]

Hmmmm. You must admit "it just works" is kind of cool aswell. The point is to avoid all the configuration knex requires. What do you think about SQL.setDialect('mysql')? Example:

let SQL = require('sql-template-strings') // will work in hybrid mode
let SQL = require('sql-template-strings').setDialect('mysql') // sets dialect to mysql and returns this

[fritzy]

makes sense to me.