peasee

Custom variables and/or stable workflow ID variable

1

In our release process with `knope`, we run a `PrepareRelease` step and raise the release changes on a PR for the rest of the team to review. As part of...

Bug: SQLite acceleration from an ODBC SQLite connection fails

1

**Describe the bug** With SQLite acceleration configured using an ODBC SQLite connection source, `spiced` outputs errors on startup for failed SQL queries: ``` 2024-07-03T00:41:20.809107Z DEBUG runtime::datasets_health_monitor: Starting datasets availability monitoring...

**Describe the bug** By default, the ODBC connector sets `max_num_rows_per_batch` to `65536`. With this configuration, and querying a set of random sample sales data, queries return in ~3.2 seconds: ```...

**Describe the bug** When loading multiple large dataset sources to the same `duck.db` acceleration database, there is a race condition where the longer running load will fail because the first...

fix: Trim whitespace from CHAR types

1

## 🗣 Description Trims whitespace from the end of `CHAR` datatypes when converting records to `RecordBatch` This follows existing behavior from PostgreSQL: [`Trailing spaces are removed when converting a character...

## Which issue does this PR close? Closes #12160 ## Rationale for this change * In SQLite, the only way to extract date information is through `strftime`. The unparser needs...

### Describe the bug Using an SQLite connection with `SqliteDialect`, and run a query that uses a date extraction function like `extract(year from date_column)`. The unparser rewrites this to `date_part`,...

fix: Dialect requires derived table alias

5

## Which issue does this PR close? Closes #12993. ## Rationale for this change Fixes a bug preventing derived logical plans from running in MySQL due to a requirement that...

### Describe the bug In some logical plans, `.derive()` creates a new subquery as a derived table like `FROM (SELECT ...)`. In MySQL, every derived table requires an alias. `.derive()`...

## 🗣 Description * Adds some integration tests for the GitHub connector ## 🔨 Related Issues * Closes #3218 * Beta docs update: TBA