In answer to your 2nd question, no.

Pg functions (ie stored procedures) are really powerful. You can 
virtually write a full application in functions and just execute the 
function (with parameters as needed) and the result is returned to priv.

Mark Bannister wrote on 5/02/2019 1:28 AM:
> 
> I've been slowly converting all queries to sql over the last year.  The 
> down side is that local sql is so quirky and simple that many queries 
> have to be broken into smaller ones in order to work.
> 
> Finally a real question, do you display data in forms directly from the 
> postgreSQL server (not sub-set data) and use the Pdox datamodel linking?
>