Support libSQL adapter

[TzviPM]

Environment

Knex version: N/A
Database + version: libsql
OS: N/A

Feature discussion / request

1. Explain what is your use case

I would like to use libSQL (https://github.com/tursodatabase/libsql) as an adapter. Locally, I will use a sqlite file, and then, in production, I will use something like Turso.

3. Explain what kind of feature would support this

Adding a new adapter for libsql or adding infrastructure to support 3rd party adapters (If that exiosts already, please kindly point me to the docs or an example :) )

5. Give some API proposal, how the feature should work

Similarly to better-sqlite3, simple define libsql as the adapter.

I would love to contribute to the poject either by:

1. Building a libsql adapter and creating a PR to contribute it back to knex
2. Helping to act as a tester for an API that allows 3rd party adapters.

[rluvaton]

Custom dialects are supported

See this for example:

https://github.com/Tomas2D/knex-firebird-dialect

We should better document it though, a PR for that welcome

[TzviPM]

One thing I'm noticing so far is that there are documentation-esque comments in the code that are not doc comments. For example, in client.js:

// The base client provides the general structure
// for a dialect specific client object.

class Client extends EventEmitter {

Also, I'm wondering how it will work to build a dialect in pure typescript. There are type definitions for the external APIs, but not for the client code, AFAICT. Turns out there are type definitions for the Client API 👍🏼