Virgiel

Ergonomic params exploration

21

I am exploring using a lightweight solution using a trait : ```rs pub trait StringSql: std::fmt::Debug + ToSql + Sync {} impl StringSql for String {} impl StringSql for &str...

Use GAT to live our Query API dream

3

This is an experimental PR showing how the soon-to-be-stabilised[GAT](https://github.com/rust-lang/rust/pull/96709) feature can help us generate less code.

Escape rust reserved keywords

1

Add support for rust reserved keywords everywhere we can escape them. To achieve this we have to use an even more custom implementation of `ToSql` and `FromSql` traits, and we...

Better container error

1

I was working on the train today and docker failed due to an unstable network. I found that our program was hiding the origin of the error and our help...

Support streaming query

1

DuckDB now supports [streaming queries](https://github.com/duckdb/duckdb/pull/6318) which do not materialize everything before returning the first rows

New codegen architecture

6

A new codegen architecture generating a whole crate instead of a single file #186. ## Changes - Generate a full crate instead of a file - Inline clients code -...

Optimising codegen using an asynchronous client and pipelining

1

When benchmarking codegen, I found that we spent most of our time communicating with the database synchronously to prepare each query one by one. By using an asynchronous client and...

Although not as convenient as `time` or `chrono`, the use of `SystemTime` does not require the use of any library.

Better use of prepare and immutable bind

1

I found a way to have explicit prepare, implicit prepare for client with cache and immutable bind: ```rs // If can cache, cache-prepare else doesn't prepare // Same as current...

Support query variant

3

It is common to have SQL queries with different filters, currently I write each variant by hand: ```sql --! raw_page_fitness: ProRawRow select ... from pro ORDER BY fitness ASC LIMIT...