Update dependencies and release new version

[stefnotch]

context

proposed solution

This package depends on knex ^0.20.1

trilogy/package.json

Line 47 in 6d73d73

"knex": "^0.20.1",

Meanwhile, knex itself has gone through 2 major version releases, with lots of changes and features. Among other things, it now supports better-sqlite3.
https://github.com/knex/knex/releases

It'd be lovely if that dependency were updated.

alternatives

Tricky, I'd love to use trilogy and avoid having to manually deal with all of this (installing sqlite, using an ORM, etc.)

additional info

When installing this package, one even gets warnings about old, deprecated dependencies. I suppose updating all dependencies might be in order?

$ npm i trilogy
npm WARN deprecated source-map-url@0.4.1: See https://github.com/lydell/source-map-url#deprecated
npm WARN deprecated urix@0.1.0: Please see https://github.com/lydell/urix#deprecated
npm WARN deprecated source-map-resolve@0.5.3: See https://github.com/lydell/source-map-resolve#deprecated
npm WARN deprecated resolve-url@0.2.1: https://github.com/lydell/resolve-url#deprecated
npm WARN deprecated debug@4.1.1: Debug versions >=3.2.0 <3.2.7 || >=4 <4.3.1 have a low-severity ReDos regression when used in a Node.js environment. It is recommended you upgrade to 3.2.7 or 4.3.1. (https://github.com/visionmedia/debug/issues/797)

added 170 packages, and audited 726 packages in 9s

[haltcase]

@stefnotch I'm with you all the way 😃 I started down this road with #114 and hit roadblocks I unfortunately don't have the time to investigate right now.

I'm more than happy to invite collaborators interested in helping maintain trilogy as well (I still have fancy static typing ambitions about v3).

[stefnotch]

I see, makes sense. I personally wouldn't have time to maintain this library, but hopefully someone else will step up to the task. :)

By the way, there is also another quite interesting library: https://github.com/koskimas/kysely
It definitely doesn't cover all the same use-cases, but I figured it'd be worth mentioning it anyways.