Support DuckDB in SQLx

[xfbs]

So, DuckDB is an interesting database that is quite similar to SQLite. They have a client crate that aims to offer an API very similar to that of rusqlite. Maybe a good candidate to support in SQLx?

If nobody wants to do this, I'll try to take it on.

[abonander]

Probably not something we would support unless a large number of people indicated an interest in it. It wouldn't be worth maintaining if no one used it.

[xfbs]

That makes sense. I'll close this issue, tho I might still try to implement support for it, but more as a learning opportunity.

[jrouaix]

@xfbs how did your experimentation went ? I'm pretty interested about it ...

[jangorecki]

Considering how well duckdb project is evolving I would suggest to give it another try. It is actually perfect complementary product to SQLite. SQLite being OLTP and duckdb OLAP.
It is feature rich. It is fast.
https://duckdb.org/

[otaviocv]

I am very interested in this feature. How could we add support to it? Is there a way to contribute to it?

[ddimaria]

+1 for this feature. DuckDB ports to WASM, it would be nice to have SQLx to check the queries at compile time/in-editor.