Support for tursogo driver. Turso re write of sqlite, not libsql #1382

Turso has released the beta for their rewrite of Sqlite, and is moving rapidly to become the replacement database in a file choice. I personally have moved to using the tursogo driver instead of sqlite for the concurrent writes, custom types and encryption.
The issue is that the new tursogo driver is not backwards compatible with sqlite (hence I can no longer use the sqlite driver)

What I would love is to be able to use golang-migrate to handle migrations in my project, the same way I did when I was using sqlite.

I've tried using the sqlite driver and it fails because I'm using column types like uuid and indexes.

I'm happy to start work on making a driver for tursogo but I'd love a little bit of guidance on how to get started.
Here is the go bindings for turso if anyone is interested: https://github.com/tursodatabase/turso/tree/main/bindings/go