I've been able to build an experimental version of Live, typed queries on real Postgres.

It started from a question I had: can a Java-shop get the "subscribe, and the UI updates when the data changes" experience of Firebase or InstantDB without giving up a real relational database and without using ORM.