[Feature]: Materialize Source

[bleonard]

Is there an existing issue for this?

• I have searched the existing issues

Is your feature request related to a problem? Please describe.

Be able to use the Materialize database as a source.
https://www.materialize.com

Possibly a destination, too.

Describe the solution you'd like.

It should be Postgres compatible.
It can be run locally and in CI similar to Clickhouse.

Later, there might be interesting things in the schedule space around their tail command, but we can start with a normal SQL source.

Describe an alternate solution.

It might be interesting to see if the current Postgres client works as-is, but it would be better have a fully supported solution.

Additional context

No response