Add support for better-sqlite3

[faulpeltz]

This adds support for the better3-sqlite driver which has been supported by Knex for while now

• minimal changes to a query in sqlite dialect (this seems related to how better-sqlite3 handles parameter binding)
• runs the same tests for sqlite3 and better-sqlite3 driver

[titanism]

Related https://github.com/knex/knex-schema-inspector/issues/147

[titanism]

@rijkvanzanten @aidenfoxx can you please merge and release this to npm? thank you 🙏

[rijkvanzanten]

Sure thing! FWIW I'm not sure if this library is maintained still. I've been out of this project for a while, and am not a member of the knex org (so can't archive this repo). The SQL queries don't really change necessarily, but just be aware that it might be worth running this off of a fork 👍🏻

[titanism]

@rijkvanzanten thank you - just ping us back once released to npm. also - you might want to regenerate the lockfile from scratch because it looks like @faulpeltz has updated it in the commit (which should be done by maintainer)

[titanism]

we use np for releases fyi it's great and simple https://github.com/sindresorhus/np

[rijkvanzanten]

we use np for releases fyi it's great and simple https://github.com/sindresorhus/np

I usually rely on a GH action for releases 🙂

[rijkvanzanten]

Should be up as 3.1.0 👍🏻

[titanism]

you're the best @rijkvanzanten 🙏 thank you

we're looking at using this for our project https://forwardemail.net - much appreciated work!

[rijkvanzanten]

Cool!! It's what's currently powering Directus although I migrated over to an in-house @directus/schema fork instead due to our desired move to ESM which wasn't shared by this org