would like to have a SQL Server layer

[italojs]

as herbs2knex support SQL Server, I would like to have the option to use SQL server in my project instead Postgres or Mongodb

Doing

[jhomarolo]

In the herbs2knex already have a example with use. You can use that code as base for your PR https://github.com/herbsjs/herbs2knex/tree/master/testdb/mssql

[rodrigodosanjosoliveira]

I look at this code, but I'm having a problem with the insert, because it tries to pass the ID with a default value and SQL Server doesn't accept it.