Lucid support for Turso (libsql) embedded replicas

[andrewbrey]

The "embedded replicas" feature (https://docs.turso.tech/features/embedded-replicas/introduction) of Turso's libsql is super compelling for (read-heavy) Adonis applications because it allows you to use a file-system-local sqlite database but then have that database be synchronized and distributed in the background to other regions. This gives you the nanosecond query times of just sqlite for a given instance of the application, but with a very convenient mechanism to distribute your data to the places where your application server is deployed.

Lucid already supports "regular" libsql but right now that isn't quite as compelling as it could be since it introduces the same http roundtrip latency you get with other client-server databases (when used with Turso and not just as a local sqlite replacement). If Lucid could take advantage of the embedded replicas feature of libsql it could produce very significant query latency improvements and all but eliminate the n+1 query problem for Adonis applications.