That's Feldera for you. It has a full blown SQL Api.

Materialize is cool as well, but is sorta hostile to self-hosting.