Add support for rqlite

[wchiquito]

Additional context
Could use this Go driver: gorqlite (https://github.com/rqlite/gorqlite).

[neilotoole]

@wchiquito: I've been tracking rqlite for several years, I'd love to add support. (Shout out to my fellow O'Toole in databases, @otoolep... apparently databases run in the family).

The way sq is currently built, only DBs that support the Go stdlib database/sql driver mechanism can be added. (Although that could be fixed with an appropriate level of abstraction). I see that there is indeed such a driver for rqlite, so rqlite support seems doable.

I need to write up a "How to write a sq driver" document. At this time, if anybody is interested in starting on rqlite support, please reach out.

[otoolep]

Thanks @neilotoole -- yes, amusing coincidence. Happy to answer any questions on rqlite if it helps.

Yeah, that driver was added in the last year. As long as you can accept a driver that doesn't support traditional transaction support, it should work I believe (rqlite supports a different type of transaction than what most relational databases support, due to the nature of the HTTP API).