That's fun. I remember doing this ~2001 with some JSP tags. Everyone thought it was terrible idea but it was really productive tbh.
What's really exciting is that it gives reactivity, reloading, declarative state and a lot of optimizations almost for free, but as I haven't implemented them in PageQL yet, the advantages are less clear.
HTML + SQL + imperative PL/SQL, running inside the database, right next to the data.
From the replies I think it mainly went out of favour because of lack of reactivity. I could port PageQL to C/Postgresl/Mysql, but I don't think it would be sufficient for a modern application, as reactivity is expected nowdays. Still, I keep it in mind to leave this kind of development as an option in the future.