Alessandro Andrioni

sql-parser: move minor `CREATE SOURCE` options to `WITH` block

2

[More context in Slack](https://materializeinc.slack.com/archives/C01CFKM1QRF/p1658843321106399), but the main idea is to move options like `REMOTE` and `TIMELINE` to the new `WITH (OPT1 VAL1 OPT2 VAL2)` block that supports order-independent settings, similar...

sql: support `trunc`

1

### Feature request `trunc` is a Postgres function that truncates (rounds towards zero) numbers to a specific amount of decimal places, defaulting to zero if the second argument is missing....

Design Avro enriched event

8

Hi, I noticed there is a feature branch to add support to Avro storage, but its last update was in 2013. Do you have any plans to work on it...

feat: JSON data types

11

Hi, I was wondering what would be the best way to treat JSON/JSONB columns from Postgres in Ibis. Currently I'm trying to treat it as a string (although it gets...

Add spectral clustering

8

Would it be in the scope of the package to add spectral clustering?

Optional steps and/or queries

3

The ability to skip some steps and/or queries sometimes would be nice. My current use case: I'm using sql-runner to load data into Redshift using a dynamically generated manifest file,...

### What version of Materialize are you using? v0.26.1-dev (0a77973af) ### How did you install Materialize? Built from source ### What is the issue? Whenever a new environment is created,...

postgres-util: refactor implementation to use openssh instead

2

Refactor implementation of SSH tunnels to use `openssh` instead of `async-ssh2-lite` due to the issues we've been facing so far. I'll add tests here soon, I just wanted to get...

Refactor SSH key handling logic with focus on testing and ensuring all memory used for storing private keys is properly zeroed out after use. Custom SerDe logic was added to...

Gracefully handle invalidated Postgres replication slots

3

### What version of Materialize are you using? v0.26.1-dev (0a77973af) ### How did you install Materialize? Built from source ### What is the issue? While trying to restart a Postgres...