risingwavelabs/risingwave ? reverse-engineered prompt

Build me a real time event streaming platform that can ingest data from databases, Kafka style streams, and webhooks, then transform it continuously and serve fresh results with very low latency. I want it to feel like one system instead of stitching together separate tools for change capture, transport, processing, and serving.

It should support SQL for creating tables and materialized views, let streams and tables be joined together, and keep query results updated automatically as new data arrives. Please also include durable storage in an open format for long term analytics, with built in management for things like compaction and cleanup. Make it usable from normal Postgres compatible tools too, so I can connect with psql or a BI tool without special setup.

If you need current details on best practices or dependencies, look up the latest docs online first.