gitmalong

AST Filter: Field without table name should refer to main table instead of joined one by default

1

```rust let mut builder = table("a") .select() .left_join("b") .hash_executor( format!("b.a_id"), format!("a.id"), ) .filter(col("year").eq(num(year))); ``` I found that the filter checks `year` against table `b`. I would have expected it to...

In order to support having multiple indexes :) - https://docs.rs/gluesql/0.14.0/gluesql/core/store/trait.IndexMut.html - https://docs.rs/gluesql/0.14.0/gluesql/core/store/trait.Index.html

Many `parsing sql CREATE_TABLE` logs when inserting batch data

2

```rust table("my_table") .insert() .columns(columns) .values(rows) .execute(glue) .await .unwrap(); ``` It seems that for every row that is inserted there is a log statement ```sql Parsing sql 'CREATE TABLE "my_table" ("id"...

Hi! It would be great if one can cast a `DateTime` to `DateTime` within the query to eliminate the need to do some filtering after retrieving the result or to...

Decimal casted to I64 when using conditional statement

3

Reproducer ```rust #[wasm_bindgen_test] async fn test_decimal_error() { let mut glue = GlueSqlStorage::glue(Some("test_decimal_error".into())).await; let table_name = "temp"; let expected_number = dec!(3.3333333); table(table_name) .create_table_if_not_exists() .add_column("number DECIMAL") .execute(&mut glue) .await .unwrap(); table(table_name) .insert()...

When creating a new project that utilizes gluesql one first needs to decide which storage should be used. Therefore it is important to know which storage backend supports which features....

Hi! When using transactions with a `IdbStorage` it fails with: ```rust glue.storage.begin(true).await.unwrap(); // leads to error: // [Storage] Transaction::begin is not supported ``` What I understood is that IndexedDb technically...

impl `TryFrom<Value>` for common `Option<T>` types

1

This works: ```rust let fee: Decimal = fee.try_into().unwrap(); ``` this doesn't ```rust let fee: Option = fee.try_into().unwrap(); ``` ```rust the trait bound `std::option::Option: std::convert::From` is not satisfied ``` Workaround ```rust...

fetch() stream

1

Hi! Is there something like a select, execute method that returns data as a `Payload` Stream similar to sqlx's `fetch()` method? Thanks

storage request: DuckDb

1

DuckDb is a promising and efficient database that does also compile to WASM https://duckdb.org/ but as it seems some effort is required to make it work with WASM + Rust...